Timesheet OT calculator
Budget: $10 – $30 USD
Will you please help me with formulas?
6th consecutive workday = Saturday
If an employee has already worked 40 “reg” hours for the week prior to Saturday, hours should calculate as follows.
Example EE worked 13 hours
0 hrs. reg.
12 hrs. DT
1 hr. DT
*Sunday will need to calculate this way as well if EE did not work Saturday
7th consecutive workday = Sunday
If an employee worked Monday through Saturday and has already worked 40 “reg” hours for the week prior to Sunday, hours should calculate as follows.
Example EE worked 10 hours
0 hrs. reg.
8 hrs. DT
2 hrs. DT
6th consecutive workday = Saturday
If an employee has already worked 40 “reg” hours for the week prior to Saturday, hours should calculate as follows.
Example EE worked 13 hours
0 hrs. reg.
12 hrs. DT
1 hr. DT
*Sunday will need to calculate this way as well if EE did not work Saturday
7th consecutive workday = Sunday
If an employee worked Monday through Saturday and has already worked 40 “reg” hours for the week prior to Sunday, hours should calculate as follows.
Example EE worked 10 hours
0 hrs. reg.
8 hrs. DT
2 hrs. DT