Spreadsheet: 791277d1660235409-formula-for-consecutive-days-worked-stryped-consecutive-days-example
Sheet: Sheet1

Timecard Report
Date Range: 07/01/2022 - 08/11/2022 and Employee Effective As Of : 08/11/2022
Company Code
 |  | Date In |  |  |  | Time In - Out |  |  |  | Hours | Pay Code |  |  | Worked Department
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Consecutive
P |  | Fri |  | 2022-07-01 00:00:00 |  | 06:50 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Mon |  | 2022-07-04 00:00:00 |  | 07:00 AM - 03:00 PM |  |  |  | 8 | HOLIDAY |  |  | 002191
P |  | Tue |  | 2022-07-05 00:00:00 |  | 07:00 AM - 03:00 PM |  |  |  | 8 | HOLIDAY |  |  | 002191
P |  | Wed |  | 2022-07-06 00:00:00 |  | 06:52 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Thu |  | 2022-07-07 00:00:00 |  | 06:54 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Fri |  | 2022-07-08 00:00:00 |  | 06:50 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Sat |  | 2022-07-09 00:00:00 |  | 05:00 AM - 01:31 PM |  |  |  | 8 |  |  |  | 002191
P |  | Sun |  | 2022-07-10 00:00:00 |  | 04:54 AM - 01:32 PM |  |  |  | 8 |  |  |  | 002191
P |  | Mon |  | 2022-07-11 00:00:00 |  | 06:53 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Tue |  | 2022-07-12 00:00:00 |  | 06:52 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Wed |  | 2022-07-13 00:00:00 |  | 06:51 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Thu |  | 2022-07-14 00:00:00 |  | 06:55 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Fri |  | 2022-07-15 00:00:00 |  | 06:53 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Sat |  | 2022-07-16 00:00:00 |  | 04:54 AM - 01:32 PM |  |  |  | 8 |  |  |  | 002191
P |  | Sun |  | 2022-07-17 00:00:00 |  | 05:00 AM - 01:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Mon |  | 2022-07-18 00:00:00 |  | 06:53 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Tue |  | 2022-07-19 00:00:00 |  | 06:49 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Wed |  | 2022-07-20 00:00:00 |  | 06:52 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Thu |  | 2022-07-21 00:00:00 |  | 06:51 AM - 03:31 PM |  |  |  | 8 |  |  |  | 002191
P |  | Fri |  | 2022-07-22 00:00:00 |  | 06:53 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Mon |  | 2022-07-25 00:00:00 |  | 07:00 AM - 03:00 PM |  |  |  | 8 | VACATION |  |  | 002191
P |  | Tue |  | 2022-07-26 00:00:00 |  | 06:50 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Wed |  | 2022-07-27 00:00:00 |  | 06:53 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Thu |  | 2022-07-28 00:00:00 |  | 07:00 AM - 03:00 PM |  |  |  | 8 | VACATION |  |  | 002191
P |  | Fri |  | 2022-07-29 00:00:00 |  | 06:51 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Sat |  | 2022-07-30 00:00:00 |  | 04:54 AM - 01:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Sun |  | 2022-07-31 00:00:00 |  | 04:50 AM - 01:32 PM |  |  |  | 8.25 |  |  |  | 002191
P |  | Mon |  | 2022-08-01 00:00:00 |  | 06:50 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Tue |  | 2022-08-02 00:00:00 |  | 06:51 AM - 03:31 PM |  |  |  | 8 |  |  |  | 002191
P |  | Wed |  | 2022-08-03 00:00:00 |  | 06:51 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Thu |  | 2022-08-04 00:00:00 |  | 06:47 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Fri |  | 2022-08-05 00:00:00 |  | 06:52 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
W |  | Mon |  | 2022-08-08 00:00:00 |  | 06:51 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
W |  | Tue |  | 2022-08-09 00:00:00 |  | 06:51 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
W |  | Wed |  | 2022-08-10 00:00:00 |  | 06:54 AM - 03:31 PM |  |  |  | 8 |  |  |  | 002191
P |  | Thu |  | 2022-08-11 00:00:00 |  | 06:52 AM - |  |  |  | 0 |  |  |  | 002191
 |  |  |  |  |  |  | Subtotal |  |  | 280.25