Spreadsheet: 731946d1620707761-regular-ot-double-time-and-40-hrs-week-ot-another-copy-sample-timesheet-v2test
Sheet: Portrait

Month: | 2021-04-01 00:00:00
Name: |  |  |  |  | OT starts after | 40 | Hours worked in the week |  |  | Weekly | Reg Hours | Over Hours | Double OT Hrs | Total Hrs worked | TOTAL  PAY
 | Rate | $ |  |  |  |  | REGULAR HOURS, we don't pay OT and DT twice
[NAME] | 1 | 20
Overtime rate | 1.5
Double OT Rate | 2
 |  |  |  |  |  |  |  |  |  | TOTAL
Week of  04/05/21 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 05:55:00 | 06:14:00 | 06:11:00 | 06:25:00 | 06:11:00 | 06:45:00
[NAME]
Lunch Ends
Log Out | 18:09:00 | 12:59:00 | 17:16:00 | 16:11:00 | 16:24:00 | 21:15:00
Hours Worked |  |  |  |  |  |  |  | FRIDAY should be [NAME]. hrs (Normal Rate), another 2.22 hrs of OT; and none of DT
[NAME] |  |  |  |  |  |  |  | SATURDAY should have 1.25 Reg (Normal Rate) - it'll give us 40 hrs/weekly; 10.75 hrs of OT [=12-1.25]; and we have correct 2.5 hrs of DT
OT |  |  |  |  |  |  |  | <diff formula for Sunday
Double OT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Between 8 and 12 = OT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Over 12 = Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Week of  04/05/21 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 08:00:00 | 10:15:00 | 11:15:00 | 07:30:00 | 08:15:00 | 11:15:00 |  |  |  |  |  |  |  |  |  | Double OT kicks in over 12 per single day
[NAME] |  |  |  |  |  | 14:00:00 |  |  |  |  |  |  |  |  |  | or after 6 days consecutive days of work then the whole day = DOT
Lunch Ends |  |  |  |  |  | 15:00:00
Log Out | 18:00:00 | 20:15:00 | 23:15:00 | 23:00:00 | 23:15:00 | 21:15:00 |  |  |  |  |  |  |  |  |  | Over 40 hours of Regular hours within 7 consecutive days = OT
Hours Worked | 10 | 10 | 12 | 15.5 | 15 | 9
[NAME] | 8 | 8 | 8 | 8 |  |  |  | should be another 8 hours at normal rate between Friday and Saturday!
OT | 2 | 2 | 4 | 4 | 12 | 8 |  | FRIDAY should be [NAME]. hrs (Normal Rate), another 4 hrs of OT; and correct 3 hrs of DT
Double OT |  |  |  | 3.5 | 3 | 1 |  | Then Saturday calculations are correct with 8 hrs OT, 1 hr DT.
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Week of  04/05/21 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 09:00:00 | 06:30:00 | 09:45:00 | 09:45:00 | 06:30:00
[NAME]
Lunch Ends
Log Out | 14:45:00 | 16:30:00 | 20:30:00 | 18:30:00 | 14:45:00
Hours Worked
[NAME]
OT |  |  |  |  |  |  |  | Friday should have .25 hrs of OT and none of DT
Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Week of  04/05/21 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 06:05:00 | 06:25:00 | 06:04:00 | 06:29:00 | 06:05:00
[NAME]
Lunch Ends
Log Out | 12:58:00 | 16:55:00 | 17:53:00 | 15:54:00 | 17:47:00
Hours Worked
[NAME] |  |  |  |  |  |  |  | FRIDAY should be [NAME]. hrs (Normal Rate), another 3.7 hrs of OT; and none of DT
OT
Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay
Week of  04/05/21 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 06:05:00 | 06:25:00 | 06:04:00 | 06:29:00 | 06:05:00
[NAME]
Lunch Ends
Log Out | 12:58:00 | 21:58:00 | 12:58:00 | 12:58:00 | 12:58:00
Hours Worked
[NAME]
OT |  |  |  |  |  |  |  | FRIDAY should be 6.88 [NAME]. hrs (Normal Rate) and none of OT & DT
Double OT
Reg. Hrs. |  | OT. Hrs. |  | Double OT Hrs |  | Total Hrs.
[NAME]. Pay |  | OT. Pay: |  | Double OT Pay |  | Total Pay