Spreadsheet: 506861d1489452943-regular-ot-and-doubletime-sample-timesheet-v1
Sheet: Portrait

Month: | 2017-03-01 00:00:00
Name: | [NAME] |  |  |  | OT starts after | 40 | hours |  | Weekly | Reg Hours | Over Hours | Double OT Hrs | Total Hrs worked | TOTAL  PAY
 | Rate | $ |  |  | Double OT starts after | 50 | Hours |  | Week of  03/01/17 | 40 | 10 | 8.25 | 58.25 | 1430
[NAME] | 1 | 20 |  |  |  |  |  |  | Week of  10/01/17 | 40 | 10 | 6 | 56 | 1340
Overtime rate | 1.5 | 30 |  |  |  |  |  |  | Week of  17/01/17 | 38 | 5 | 1.000000000000002 | 43 | 950.0000000000001
Double OT Rate | 2 | 40 |  |  |  |  |  |  | Week of  24/01/17 | 5 | 0 | 0 | 5 | 100
 |  |  |  |  |  |  |  |  | Week of  31/01/17 | 5 | 0 | 0 | 5 | 100
 |  |  |  |  |  |  |  |  | TOTAL | 128 | 25 | 15.25 | 167.25 | 3920
Week of  03/01/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 09:30:00 | 09:30:00 | 09:30:00 | 08:30:00 | 07:30:00 | 10:45:00 | 11:00:00
[NAME] |  |  |  |  |  | 15:00:00
Lunch Ends |  |  |  |  |  | 17:00:00
Log Out | 14:30:00 | 14:30:00 | 14:30:00 | 19:30:00 | 21:30:00 | 22:30:00 | 19:30:00
Hours Worked | 5 | 5 | 5 | 11 | 14 | 9.749999999999998 | 8.5
[NAME] | 5 | 5 | 5 | 8 | 8 | 8 | 8
OT | 0 | 0 | 0 | 3 | 4 | 1.749999999999998 | 0.5
Double OT | 0 | 0 | 0 | 0 | 2 | 0 | 0
Reg. Hrs. | 40 | OT. Hrs. | 10 | Double OT Hrs | 8.25 | Total Hrs. | 58.25
[NAME]. Pay | 800 | OT. Pay: | 300 | Double OT Pay | 330 | Total Pay | 1430
Week of  10/01/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00
[NAME]
Lunch Ends
Log Out | 17:30:00 | 17:30:00 | 17:30:00 | 17:30:00 | 17:30:00 | 17:30:00 | 17:30:00
Hours Worked | 8 | 8 | 8 | 8 | 8 | 8 | 8
[NAME] | 8 | 8 | 8 | 8 | 8 | 8 | 8
OT | 0 | 0 | 0 | 0 | 0 | 0 | 0
Double OT | 0 | 0 | 0 | 0 | 0 | 0 | 0
Reg. Hrs. | 40 | OT. Hrs. | 10 | Double OT Hrs | 6 | Total Hrs. | 56
[NAME]. Pay | 800 | OT. Pay: | 300 | Double OT Pay | 240 | Total Pay | 1340
Week of  17/01/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00 | 09:30:00
[NAME]
Lunch Ends
Log Out | 14:30:00 | 14:30:00 | 14:30:00 | 22:30:00 | 14:30:00 | 14:30:00 | 14:30:00
Hours Worked | 5 | 5 | 5 | 13 | 5 | 5 | 5
[NAME] | 5 | 5 | 5 | 8 | 5 | 5 | 5
OT | 0 | 0 | 0 | 4 | 0 | 0 | 0
Double OT | 0 | 0 | 0 | 1.000000000000002 | 0 | 0 | 0
Reg. Hrs. | 38 | OT. Hrs. | 5 | Double OT Hrs | 1.000000000000002 | Total Hrs. | 43
[NAME]. Pay | 760 | OT. Pay: | 150 | Double OT Pay | 40.00000000000007 | Total Pay | 950.0000000000001
Week of  24/01/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In | 09:30:00
[NAME]
Lunch Ends
Log Out | 14:30:00
Hours Worked | 5 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 5 | 0 | 0 | 0 | 0 | 0 | 0
OT | 0 | 0 | 0 | 0 | 0 | 0 | 0
Double OT | 0 | 0 | 0 | 0 | 0 | 0 | 0
Reg. Hrs. | 5 | OT. Hrs. | 0 | Double OT Hrs | 0 | Total Hrs. | 5
[NAME]. Pay | 100 | OT. Pay: | 0 | Double OT Pay | 0 | Total Pay | 100
Week of  31/01/17 | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
Log In |  | 09:30:00
[NAME]
Lunch Ends
Log Out |  | 14:30:00
Hours Worked | 0 | 5 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 5 | 0 | 0 | 0 | 0 | 0
OT | 0 | 0 | 0 | 0 | 0 | 0 | 0
Double OT | 0 | 0 | 0 | 0 | 0 | 0 | 0
Reg. Hrs. | 5 | OT. Hrs. | 0 | Double OT Hrs | 0 | Total Hrs. | 5
[NAME]. Pay | 100 | OT. Pay: | 0 | Double OT Pay | 0 | Total Pay | 100