Time Sheet Help

Forum|Forum|7 years ago
July 10, 2018
1 reply
716 views

I have no prior experience in Adobe Script and need help solving an overtime issue. I have found how to add the bottom row easy enough. Now I need when the Reg Column totals to 40 I would like the time to roll over into the overtime column automatically. Not even sure if this is possible, but if it is, please help. The link below is our time sheet.

Microsoft OneDrive - Access files anywhere. Create docs with free Office Online.

This topic has been closed for replies.

try67

Community Expert

Sure, it's possible. Are you referring to the Total fields at the bottom, though, or to the Reg/Over fields in each row?

Don't you want the Reg field to be the sum of the day fields in that row?

B

brandonv70117124Author

Participant

I am referring to the Reg/Over fields in each row. For example, Row 1 you worked 39 hours wed. Row 2 you worked 2 hours on a job Thursday. On row 2 I need it to put 1 hour in the Reg and move that extra hour to overtime. I updated the link to show what I'm talking about. Hope this makes sense.

try67

Community Expert

Ah, so it's a rolling calculation from week to week? That's a much more complicated calculation, as it needs to take all the previous rows into account.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded