Spreadsheet: 680446d1591025121-calculate-night-shift-hours-copy-of-inventory-service-team-timesheet-2020-copy-autosaved-autosaved-
Sheet: May

 | Employee Time Sheet
 | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES | 2015-12-01 00:00:00 | 31 | 1
 | SAP ID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | 2016-01-01 00:00:00 | 31 | 0
 | Month |  |  | 2020-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Excused | 2016-02-01 00:00:00 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-03-01 00:00:00 | 31
 | Date | Day | Time In | Time Out | Hours Worked | Holiday/ Vacation/Day-Off | Shift duty | Normal Working Hours | OT | Regular OT | Weekend OT | Shift Hours | Remarks | [NAME] | Shift End | Shift Hours | Shift Hours>11 |  | 2016-05-01 00:00:00 | 31
 | 2020-05-01 00:00:00 | Fri | 21:00:00 | 06:00:00 |  | NO | YES |  |  |  |  |  |  | 18:00:00 | 05:00:00 |  |  |  | 2016-06-01 00:00:00 | 30
 |  | Sat | 18:00:00 | 03:00:00 |  | NO | YES |  |  |  |  |  |  | 18:00:00 | 05:00:00 |  |  |  | 2016-07-01 00:00:00 | 31
 |  | Sun | 19:00:00 | 03:00:00 |  | NO | YES |  |  |  |  |  |  | 18:00:00 | 05:00:00 |  |  |  | 2016-08-01 00:00:00 | 31
 |  | Mon | 22:00:00 | 06:00:00 |  | NO | YES |  |  |  |  |  |  | 18:00:00 | 05:00:00 |  |  |  | 2016-09-01 00:00:00 | 30
 |  | Tue |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00 |  |  |  | 2016-10-01 00:00:00 | 31
 |  | Wed |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00 |  |  |  | 2016-11-01 00:00:00 | 30
 |  | Thu |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00 |  |  |  | 2016-12-01 00:00:00 | 31
 |  | Fri |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00 |  |  |  | 2017-01-01 00:00:00 | 31
 |  | Sat |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Sun |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Mon |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Tue |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Wed |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Thu |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Fri |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Sat |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Sun |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Mon |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Tue |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Wed |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Thu |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Fri |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Sat |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Sun |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Mon |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Tue |  |  |  | Excused | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Wed |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Thu |  |  |  | YES | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Fri |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Sat |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 |  | Sun |  |  |  | NO | NO |  |  |  |  |  |  | 18:00:00 | 05:00:00
 | COMMENTS
 | EMPLOYEE'S SIGNATURE |  |  |  |  |  |  |  | MANAGER/SUPERVISOR APPROVAL