Spreadsheet: 791272d1660233229-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 |  | 07/01/2022 |  | 06:50 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Mon |  | 07/04/2022 |  | 07:00 AM - 03:00 PM |  |  |  | 8 | HOLIDAY |  |  | 002191
P |  | Tue |  | 07/05/2022 |  | 07:00 AM - 03:00 PM |  |  |  | 8 | HOLIDAY |  |  | 002191
P |  | Wed |  | 07/06/2022 |  | 06:52 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Thu |  | 07/07/2022 |  | 06:54 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Fri |  | 07/08/2022 |  | 06:50 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Sat |  | 07/09/2022 |  | 05:00 AM - 01:31 PM |  |  |  | 8 |  |  |  | 002191
P |  | Sun |  | 07/10/2022 |  | 04:54 AM - 01:32 PM |  |  |  | 8 |  |  |  | 002191
P |  | Mon |  | 07/11/2022 |  | 06:53 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Tue |  | 07/12/2022 |  | 06:52 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Wed |  | 07/13/2022 |  | 06:51 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Thu |  | 07/14/2022 |  | 06:55 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Fri |  | 07/15/2022 |  | 06:53 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Sat |  | 07/16/2022 |  | 04:54 AM - 01:32 PM |  |  |  | 8 |  |  |  | 002191
P |  | Sun |  | 07/17/2022 |  | 05:00 AM - 01:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Mon |  | 07/18/2022 |  | 06:53 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Tue |  | 07/19/2022 |  | 06:49 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Wed |  | 07/20/2022 |  | 06:52 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Thu |  | 07/21/2022 |  | 06:51 AM - 03:31 PM |  |  |  | 8 |  |  |  | 002191
P |  | Fri |  | 07/22/2022 |  | 06:53 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Mon |  | 07/25/2022 |  | 07:00 AM - 03:00 PM |  |  |  | 8 | VACATION |  |  | 002191
P |  | Tue |  | 07/26/2022 |  | 06:50 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Wed |  | 07/27/2022 |  | 06:53 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Thu |  | 07/28/2022 |  | 07:00 AM - 03:00 PM |  |  |  | 8 | VACATION |  |  | 002191
P |  | Fri |  | 07/29/2022 |  | 06:51 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Sat |  | 07/30/2022 |  | 04:54 AM - 01:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Sun |  | 07/31/2022 |  | 04:50 AM - 01:32 PM |  |  |  | 8.25 |  |  |  | 002191
P |  | Mon |  | 08/01/2022 |  | 06:50 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Tue |  | 08/02/2022 |  | 06:51 AM - 03:31 PM |  |  |  | 8 |  |  |  | 002191
P |  | Wed |  | 08/03/2022 |  | 06:51 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Thu |  | 08/04/2022 |  | 06:47 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
P |  | Fri |  | 08/05/2022 |  | 06:52 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
W |  | Mon |  | 08/08/2022 |  | 06:51 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
W |  | Tue |  | 08/09/2022 |  | 06:51 AM - 03:30 PM |  |  |  | 8 |  |  |  | 002191
W |  | Wed |  | 08/10/2022 |  | 06:54 AM - 03:31 PM |  |  |  | 8 |  |  |  | 002191
P |  | Thu |  | 08/11/2022 |  | 06:52 AM - |  |  |  | 0 |  |  |  | 002191
 |  |  |  |  |  |  | Subtotal |  |  | 280.25