Spreadsheet: 525668d1498828057-formula-for-timecard-auto-calculation-streets-wk-end-070117
Sheet: Sheet1

No: 20215 |  | Name: [NAME] |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON | 05:59:00 | 15:58:00
06/27 | TUE | 06:00:00 | 15:58:00
06/28 | WED | 05:58:00 | 15:58:00
06/29 | THU | 06:01:00 | 15:58:00
06/30 | FRI
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 22916 |  | Name: [NAME] |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON
06/27 | TUE | 05:58:00 | 15:58:00
06/28 | WED | 05:58:00 | 15:58:00
06/29 | THU | 06:00:00 | 15:58:00
06/30 | FRI | 05:58:00 | 16:00:00
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 72282 |  | Name: Coy Dave |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON
06/27 | TUE | 05:59:00 | 15:59:00
06/28 | WED | 05:59:00 | 15:59:00
06/29 | THU | 06:00:00 | 15:58:00
06/30 | FRI | 06:00:00 | 14:00:00
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 82310 |  | Name: [NAME] |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON | 06:00:00 | 15:58:00
06/27 | TUE | 05:59:00 | 15:58:00
06/28 | WED | 05:59:00 | 15:58:00
06/29 | THU | 06:00:00 | 15:58:00
06/30 | FRI
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 121514 |  | Name: [NAME] |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON | 05:59:00 | 15:58:00
06/27 | TUE | 05:59:00 | 15:58:00
06/28 | WED | 06:56:00 | 15:58:00
06/29 | THU | 05:59:00 | 12:58:00
06/30 | FRI
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 41116 |  | Name: [NAME] |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON
06/27 | TUE
06/28 | WED | 05:58:00 | 15:58:00
06/29 | THU | 06:00:00 | 15:58:00
06/30 | FRI
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 70113 |  | Name: [NAME] |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON | 07:00:00 | 11:58:00 | 12:58:00 | 15:58:00
06/27 | TUE | 06:58:00 | 15:58:00
06/28 | WED | 07:01:00 | 12:00:00 | 13:00:00 | 15:58:00
06/29 | THU | 07:01:00 | 11:59:00 | 12:58:00 | 15:59:00
06/30 | FRI | 07:00:00 | 11:59:00 | 12:58:00 | 15:59:00
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 70196 |  | Name: [NAME] |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON
06/27 | TUE | 01:55:00 | 11:53:00
06/28 | WED | 01:55:00 | 10:57:00
06/29 | THU | 02:55:00 | 10:58:00
06/30 | FRI | 02:55:00 | 10:58:00
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 50514 |  | Name: [NAME] |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON
06/27 | TUE | 05:59:00 | 15:58:00
06/28 | WED | 05:58:00 | 16:00:00
06/29 | THU | 06:00:00 | 15:58:00
06/30 | FRI
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 50911 |  | Name: Roan Dustin |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON | 06:00:00 | 15:58:00
06/27 | TUE | 05:59:00 | 15:58:00
06/28 | WED
06/29 | THU
06/30 | FRI
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 70912 |  | Name: [NAME] |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON
06/27 | TUE | 05:58:00 | 15:58:00
06/28 | WED | 05:58:00 | 15:58:00
06/29 | THU | 06:01:00 | 15:58:00
06/30 | FRI | 06:02:00 | 15:58:00
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 112204 |  | Name: Schoonover R |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON | 05:59:00 | 11:58:00
06/27 | TUE | 06:00:00 | 11:58:00
06/28 | WED | 05:59:00 | 14:04:00
06/29 | THU | 06:01:00 | 09:58:00
06/30 | FRI
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 101110 |  | Name: Sevits EZ |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON | 06:02:00 | 15:59:00
06/27 | TUE | 06:00:00 | 15:58:00
06/28 | WED | 06:03:00 | 08:31:00 | 10:43:00 | 15:58:00
06/29 | THU | 06:01:00 | 15:58:00
06/30 | FRI
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature:
No: 12152014 |  | Name: Watkins Blake |  |  |  | Dept: 10-52 |  | Shift: Shift1
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT)
06/25 | SUN
06/26 | MON | 05:59:00 | 15:58:00
06/27 | TUE | 05:59:00 | 15:58:00
06/28 | WED | 05:58:00 | 15:59:00
06/29 | THU | 06:01:00 | 10:01:00
06/30 | FRI
07/01 | SAT
 |  |  |  |  |  |  |  |  | TOTAL:
Work Total (hrs): |  |  |  | Overtime (hrs) |  |  | Other (hrs):
Employee Signature: |  |  |  |  | Manager Signature: