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

ANDEAJ0215 |  | Name: [NAME], [NAME] |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON | 05:59:00 | 15:58:00 |  |  |  |  |  |  | 9.98333333269693 | 0 | 0
06/27 | TUE | 06:00:00 | 15:58:00 |  |  |  |  |  |  | 9.966666666325182 | 0 | 0
06/28 | WED | 05:58:00 | 15:58:00 |  |  |  |  |  |  | 9.99999999976717 | 0 | 0
06/29 | THU | 06:01:00 | 15:58:00 |  |  |  |  |  |  | 9.949999999953434 | 0 | 0
06/30 | FRI |  |  |  |  |  |  |  |  | 0 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 39.89999999874271 | 0 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 39.89999999874271 | Overtime (hrs) |  | 0 | Call-out |  | 0
Stand-By |  | Vacation |  | 0 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
CIMAML0513 |  | Name: [NAME], [NAME] |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON |  |  |  |  |  |  |  |  | 0 | 0 | 0
06/27 | TUE | 05:58:00 | 15:58:00 |  |  |  |  |  |  | 9.99999999976717 | 0 | 0
06/28 | WED | 05:58:00 | 15:58:00 |  |  |  |  |  |  | 9.99999999976717 | 0 | 0
06/29 | THU | 06:00:00 | 15:58:00 |  |  |  |  |  |  | 9.966666666325182 | 0 | 0
06/30 | FRI | 05:58:00 | 16:00:00 |  |  |  |  |  |  | 10 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 39.96666666585952 | 0 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 39.96666666585952 | Overtime (hrs) |  | 0 | Call-out |  | 0
Stand-By |  | Vacation |  | 0 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
COYDO0320 |  | Name: Coy, [NAME] |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON |  |  |  |  |  |  |  |  | 0 | 0 | 0
06/27 | TUE | 05:59:00 | 15:59:00 |  |  |  |  |  |  | 9.99999999976717 | 0 | 0
06/28 | WED | 05:59:00 | 15:59:00 |  |  |  |  |  |  | 9.99999999976717 | 0 | 0
06/29 | THU | 06:00:00 | 15:58:00 |  |  |  |  |  |  | 9.966666666325182 | 0 | 0
06/30 | FRI | 06:00:00 | 14:00:00 |  |  |  |  |  |  | 10 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 39.96666666585952 | 0 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 39.96666666585952 | Overtime (hrs) |  | 0 | Call-out |  | 0
Stand-By |  | Vacation |  | 0 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
LECKRR0810 |  | Name: Leckbee, Randall |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON | 06:00:00 | 15:58:00 |  |  |  |  |  |  | 9.966666666325182 | 0 | 0
06/27 | TUE | 05:59:00 | 15:58:00 |  |  |  |  |  |  | 9.98333333269693 | 0 | 0
06/28 | WED | 05:59:00 | 15:58:00 |  |  |  |  |  |  | 9.98333333269693 | 0 | 0
06/29 | THU | 06:00:00 | 15:58:00 |  |  |  |  |  |  | 9.966666666325182 | 0 | 0
06/30 | FRI |  |  |  |  |  |  |  |  | 0 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 39.89999999804422 | 0 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 39.89999999804422 | Overtime (hrs) |  | 0 | Call-out |  | 0
Stand-By |  | Vacation |  | 0 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
MARTDL1214 |  | Name: Martin, Dustin |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON | 05:59:00 | 15:58:00 |  |  |  |  |  |  | 9.98333333269693 | 0 | 0
06/27 | TUE |  |  |  |  |  |  |  |  | 0 | 0 | 0
06/28 | WED | 06:56:00 | 15:58:00 |  |  |  |  |  |  | 9.033333332743496 | 0 | 0
06/29 | THU | 05:59:00 | 12:58:00 |  |  |  |  |  |  | 6.98333333269693 | 0 | 0
06/30 | FRI |  |  |  |  |  |  |  |  | 0 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 25.99999999813735 | 0 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 25.99999999813735 | Overtime (hrs) |  | 0 | Call-out |  | 0
Stand-By | 5 | Vacation |  | 0 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
MILLJD0416 |  | Name: [NAME], [NAME] |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 10
06/27 | TUE |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 10
06/28 | WED | 05:58:00 | 15:58:00 |  |  |  |  |  |  | 9.99999999976717 | 0 | 0
06/29 | THU | 06:00:00 | 15:58:00 |  |  |  |  |  |  | 9.966666666325182 | 0 | 0
06/30 | FRI |  |  |  |  |  |  |  |  | 0 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 19.96666666609235 | 0 | 0 | 20 | 0 | 0
Work Total (hrs): |  |  | 19.96666666609235 | Overtime (hrs) |  | 0 | Call-out |  | 0
Stand-By |  | Vacation |  | 20 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
OSBOJS0713 |  | Name: Osborn, Justin |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON | 07:00:00 | 11:58:00 | 12:58:00 | 15:58:00 |  |  |  |  | 8 | 0 | 0
06/27 | TUE | 06:58:00 | 15:58:00 |  |  |  |  |  |  | 8 | 1 | 0
06/28 | WED | 07:01:00 | 12:00:00 | 13:00:00 | 15:58:00 |  |  |  |  | 8 | 0 | 0
06/29 | THU | 07:01:00 | 11:59:00 | 12:58:00 | 15:59:00 |  |  |  |  | 8 | 0 | 0
06/30 | FRI | 07:00:00 | 11:59:00 | 12:58:00 | 15:59:00 |  |  |  |  | 8 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 40 | 1 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 40 | Overtime (hrs) |  | 1 | Call-out |  | 0
Stand-By |  | Vacation |  | 0 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
POWERL0089 |  | Name: [NAME], [NAME] |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON |  |  |  |  |  |  |  |  | 0 | 0 | 0
06/27 | TUE | 01:55:00 | 11:53:00 |  |  |  |  |  |  | 8 | 2 | 0
06/28 | WED | 01:55:00 | 10:57:00 |  |  |  |  |  |  | 8 | 1 | 0
06/29 | THU | 02:55:00 | 10:58:00 |  |  |  |  |  |  | 8 | 0 | 0
06/30 | FRI | 02:55:00 | 10:58:00 |  |  |  |  |  |  | 8 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 32 | 3 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 32 | Overtime (hrs) |  | 3 | Call-out |  | 0
Stand-By |  | Vacation |  | 0 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
RIDERJA0414 |  | Name: [NAME], [NAME] |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON |  |  |  |  |  |  |  |  | 0 | 0 | 0
06/27 | TUE | 05:59:00 | 15:58:00 |  |  |  |  |  |  | 9.98333333269693 | 0 | 0
06/28 | WED | 05:58:00 | 16:00:00 |  |  |  |  |  |  | 10 | 0 | 0
06/29 | THU | 06:00:00 | 15:58:00 |  |  |  |  |  |  | 9.966666666325182 | 0 | 0
06/30 | FRI |  |  |  |  |  |  |  |  | 0 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 29.94999999902211 | 0 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 29.94999999902211 | Overtime (hrs) |  | 0 | Call-out |  | 0
Stand-By |  | Vacation |  | 0 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
ROANDD0511 |  | Name: Roan, Dustin |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON | 06:00:00 | 15:58:00 |  |  |  |  |  |  | 9.966666666325182 | 0 | 0
06/27 | TUE | 05:59:00 | 15:58:00 |  |  |  |  |  |  | 9.98333333269693 | 0 | 0
06/28 | WED |  |  |  |  |  |  |  |  | 0 | 0 | 0
06/29 | THU |  |  |  |  |  |  |  |  | 0 | 0 | 0
06/30 | FRI |  |  |  |  |  |  |  |  | 0 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 19.94999999902211 | 0 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 19.94999999902211 | Overtime (hrs) |  | 0 | Call-out |  | 0
Stand-By |  | Vacation |  | 0 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
RUSKRG0412 |  | Name: [NAME], [NAME] |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON |  |  |  |  |  |  |  |  | 0 | 0 | 0
06/27 | TUE | 05:58:00 | 15:58:00 |  |  |  |  |  |  | 9.99999999976717 | 0 | 0
06/28 | WED | 05:58:00 | 15:58:00 |  |  |  |  |  |  | 9.99999999976717 | 0 | 0
06/29 | THU | 06:01:00 | 15:58:00 |  |  |  |  |  |  | 9.949999999953434 | 0 | 0
06/30 | FRI | 06:02:00 | 15:58:00 |  |  |  |  |  |  | 9.933333332883194 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 39.88333333237097 | 0 | 0 | 0 | 0 | 0
Work Total (hrs): |  |  | 39.88333333237097 | Overtime (hrs) |  | 0 | Call-out |  | 0
Stand-By | 5 | Vacation |  | 0 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
SCHORS1104 |  | Name: Schoonover, [NAME] |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON | 05:59:00 | 11:58:00 |  |  |  |  |  |  | 5.98333333292976 | 0 | 0 | 4
06/27 | TUE | 06:00:00 | 11:58:00 |  |  |  |  |  |  | 5.966666666558012 | 0 | 0 | 4
06/28 | WED | 05:59:00 | 14:04:00 |  |  |  |  |  |  | 10 | 0 | 0
06/29 | THU | 06:01:00 | 09:58:00 |  |  |  |  |  |  | 3.949999999953434 | 0 | 0 | 6
06/30 | FRI |  |  |  |  |  |  |  |  | 0 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 25.89999999944121 | 0 | 0 | 14 | 0 | 0
Work Total (hrs): |  |  | 25.89999999944121 | Overtime (hrs) |  | 0 | Call-out |  | 0
Stand-By |  | Vacation |  | 14 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
SEVIEJ0410 |  | Name: [NAME], Ezekiel |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON | 06:02:00 | 15:59:00 |  |  |  |  |  |  | 9.949999999953434 | 0 | 0
06/27 | TUE | 06:00:00 | 15:58:00 |  |  |  |  |  |  | 9.966666666325182 | 0 | 0
06/28 | WED | 06:03:00 | 08:31:00 | 10:43:00 | 15:58:00 |  |  |  |  | 7.716666667023674 | 0 | 0 |  | 2.25
06/29 | THU | 06:01:00 | 15:58:00 |  |  |  |  |  |  | 9.949999999953434 | 0 | 0
06/30 | FRI |  |  |  |  |  |  |  |  | 0 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 37.58333333325572 | 0 | 0 | 0 | 2.25 | 0
Work Total (hrs): |  |  | 37.58333333325572 | Overtime (hrs) |  | 0 | Call-out |  | 0
Stand-By |  | Vacation |  | 0 | [NAME] |  | 2.25 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date:
WATKBJ1214 |  | Name: [NAME], Blake |  |  |  | Dept: 10-52 |  |  |  | Daily totals
Date | Week | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | (IN) | (OUT) | Reg Hours | OT Hours | Callout Hours | Vac | [NAME] | Holiday
06/25 | SUN |  |  |  |  |  |  |  |  |  |  | 0
06/26 | MON | 05:59:00 | 15:58:00 |  |  |  |  |  |  | 9.98333333269693 | 0 | 0
06/27 | TUE | 05:59:00 | 15:58:00 |  |  |  |  |  |  | 9.98333333269693 | 0 | 0
06/28 | WED | 05:58:00 | 15:59:00 |  |  |  |  |  |  | 10 | 0 | 0
06/29 | THU | 06:01:00 | 10:01:00 |  |  |  |  |  |  | 4.000000000465661 | 0 | 0 | 6
06/30 | FRI |  |  |  |  |  |  |  |  | 0 | 0 | 0
07/01 | SAT |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Totals | 33.96666666585952 | 0 | 0 | 6 | 0 | 0
Work Total (hrs): |  |  | 33.96666666585952 | Overtime (hrs) |  | 0 | Call-out |  | 0
Stand-By |  | Vacation |  | 6 | [NAME] |  | 0 |  | Meals |  | Holiday |  | 0
Employee Signature: |  |  |  |  | Manager Signature: |  |  |  |  | Date: