Spreadsheet: 877921d1724853121-creating-a-template-using-the-attached-data-call-center-login-logout-data-attendance-test
Sheet: Desire outcome

Name | Calendar Date | Login | Logout | Shift Start | Expected Login | Expected Logout | Late in Mins | Expected Duration in Mins | Actual Duration in Mins | Over/(Under) in Mins |  | [NAME]
[NAME] | 2024-07-01 00:00:00 |  |  | OFF
[NAME] | 2024-07-02 00:00:00 |  |  | 5A
[NAME] | 2024-07-03 00:00:00 |  |  | 5A
[NAME] | 2024-07-04 00:00:00 |  |  | 5A |  |  |  |  |  |  |  | Conditional Formatting: =AND(ISNUMBER(F2),C2="")
[NAME] | 2024-07-05 00:00:00 |  |  | 5A
[NAME] | 2024-07-06 00:00:00 |  |  | 5A
[NAME] | 2024-07-07 00:00:00 |  |  | OFF
[NAME] | 2024-07-08 00:00:00 |  |  | OFF
[NAME] | 2024-07-09 00:00:00 |  |  | 5A
[NAME] | 2024-07-10 00:00:00 |  |  | 5A
[NAME] | 2024-07-11 00:00:00 |  |  | 5A
[NAME] | 2024-07-12 00:00:00 |  |  | 5A
[NAME] | 2024-07-13 00:00:00 |  |  | 5A
[NAME] | 2024-07-14 00:00:00 |  |  | OFF
[NAME] | 2024-07-15 00:00:00 |  |  | OFF
[NAME] | 2024-07-16 00:00:00 |  |  | 5A
[NAME] | 2024-07-17 00:00:00 |  |  | 5A
[NAME] | 2024-07-18 00:00:00 |  |  | 5A
[NAME] | 2024-07-19 00:00:00 |  |  | 5A
[NAME] | 2024-07-20 00:00:00 |  |  | 5A
[NAME] | 2024-07-21 00:00:00 |  |  | OFF
[NAME] | 2024-07-22 00:00:00 |  |  | OFF
[NAME] | 2024-07-23 00:00:00 |  |  | 5A
[NAME] | 2024-07-24 00:00:00 |  |  | 5A
[NAME] | 2024-07-25 00:00:00 |  |  | 5A
[NAME] | 2024-07-26 00:00:00 |  |  | 5A
[NAME] | 2024-07-27 00:00:00 |  |  | 5A
[NAME] | 2024-07-28 00:00:00 |  |  | OFF
[NAME] | 2024-07-29 00:00:00 |  |  | OFF
[NAME] | 2024-07-30 00:00:00 |  |  | 5A
[NAME] | 2024-07-31 00:00:00 |  |  | 5A
[NAME] | 2024-08-01 00:00:00 |  |  | 5A
Alvin | 2024-07-01 00:00:00 |  |  | VL
Alvin | 2024-07-02 00:00:00 |  |  | 5A
Alvin | 2024-07-03 00:00:00 |  |  | 5A
Alvin | 2024-07-04 00:00:00 |  |  | 5A
Alvin | 2024-07-05 00:00:00 |  |  | OFF
Alvin | 2024-07-06 00:00:00 |  |  | OFF
Alvin | 2024-07-07 00:00:00 |  |  | 5A
Alvin | 2024-07-08 00:00:00 |  |  | 5A
Alvin | 2024-07-09 00:00:00 |  |  | 5A
Alvin | 2024-07-10 00:00:00 |  |  | 5A
Alvin | 2024-07-11 00:00:00 |  |  | 5A
Alvin | 2024-07-12 00:00:00 |  |  | OFF
Alvin | 2024-07-13 00:00:00 |  |  | OFF
Alvin | 2024-07-14 00:00:00 |  |  | 5A
Alvin | 2024-07-15 00:00:00 |  |  | 5A
Alvin | 2024-07-16 00:00:00 |  |  | 5A
Alvin | 2024-07-17 00:00:00 |  |  | 5A
Alvin | 2024-07-18 00:00:00 |  |  | 5A
Alvin | 2024-07-19 00:00:00 |  |  | OFF
Alvin | 2024-07-20 00:00:00 |  |  | OFF
Alvin | 2024-07-21 00:00:00 |  |  | 5A
Alvin | 2024-07-22 00:00:00 |  |  | 5A
Alvin | 2024-07-23 00:00:00 |  |  | 5A
Alvin | 2024-07-24 00:00:00 |  |  | 5A
Alvin | 2024-07-25 00:00:00 |  |  | 5A
Alvin | 2024-07-26 00:00:00 |  |  | OFF
Alvin | 2024-07-27 00:00:00 |  |  | OFF
Alvin | 2024-07-28 00:00:00 |  |  | 5A
Alvin | 2024-07-29 00:00:00 |  |  | 5A
Alvin | 2024-07-30 00:00:00 |  |  | 5A
Alvin | 2024-07-31 00:00:00 |  |  | 5A
Alvin | 2024-08-01 00:00:00 |  |  | 5A
Breech | 2024-07-01 00:00:00 |  |  | 9P
Breech | 2024-07-02 00:00:00 |  |  | 9P
Breech | 2024-07-03 00:00:00 |  |  | 9P
Breech | 2024-07-04 00:00:00 |  |  | 9P
Breech | 2024-07-05 00:00:00 |  |  | 9P
Breech | 2024-07-06 00:00:00 |  |  | OFF
Breech | 2024-07-07 00:00:00 |  |  | OFF
Breech | 2024-07-08 00:00:00 |  |  | 9P
Breech | 2024-07-09 00:00:00 |  |  | 9P
Breech | 2024-07-10 00:00:00 |  |  | 9P
Breech | 2024-07-11 00:00:00 |  |  | 9P
Breech | 2024-07-12 00:00:00 |  |  | 9P
Breech | 2024-07-13 00:00:00 |  |  | OFF
Breech | 2024-07-14 00:00:00 |  |  | OFF
Breech | 2024-07-15 00:00:00 |  |  | 9P
Breech | 2024-07-16 00:00:00 |  |  | 9P
Breech | 2024-07-17 00:00:00 |  |  | 9P
Breech | 2024-07-18 00:00:00 |  |  | 9P
Breech | 2024-07-19 00:00:00 |  |  | 9P
Breech | 2024-07-20 00:00:00 |  |  | OFF
Breech | 2024-07-21 00:00:00 |  |  | OFF
Breech | 2024-07-22 00:00:00 |  |  | 9P
Breech | 2024-07-23 00:00:00 |  |  | 9P
Breech | 2024-07-24 00:00:00 |  |  | 9P
Breech | 2024-07-25 00:00:00 |  |  | 9P
Breech | 2024-07-26 00:00:00 |  |  | 9P
Breech | 2024-07-27 00:00:00 |  |  | OFF
Breech | 2024-07-28 00:00:00 |  |  | OFF
Breech | 2024-07-29 00:00:00 |  |  | 9P
Breech | 2024-07-30 00:00:00 |  |  | 9P
Breech | 2024-07-31 00:00:00 |  |  | 9P
Breech | 2024-08-01 00:00:00 |  |  | 9P
Caudillo | 2024-07-01 00:00:00 |  |  | 9P
Caudillo | 2024-07-02 00:00:00 |  |  | 9P
Caudillo | 2024-07-03 00:00:00 |  |  | 9P
Caudillo | 2024-07-04 00:00:00 |  |  | 9P
Caudillo | 2024-07-05 00:00:00 |  |  | OFF
Caudillo | 2024-07-06 00:00:00 |  |  | OFF
Caudillo | 2024-07-07 00:00:00 |  |  | 9P
Caudillo | 2024-07-08 00:00:00 |  |  | 9P
Caudillo | 2024-07-09 00:00:00 |  |  | 9P
Caudillo | 2024-07-10 00:00:00 |  |  | 9P
Caudillo | 2024-07-11 00:00:00 |  |  | 9P
Caudillo | 2024-07-12 00:00:00 |  |  | OFF
Caudillo | 2024-07-13 00:00:00 |  |  | OFF
Caudillo | 2024-07-14 00:00:00 |  |  | 9P
Caudillo | 2024-07-15 00:00:00 |  |  | 9P
Caudillo | 2024-07-16 00:00:00 |  |  | 9P
Caudillo | 2024-07-17 00:00:00 |  |  | 9P
Caudillo | 2024-07-18 00:00:00 |  |  | 9P
Caudillo | 2024-07-19 00:00:00 |  |  | OFF
Caudillo | 2024-07-20 00:00:00 |  |  | OFF
Caudillo | 2024-07-21 00:00:00 |  |  | 9P
Caudillo | 2024-07-22 00:00:00 |  |  | 9P
Caudillo | 2024-07-23 00:00:00 |  |  | 9P
Caudillo | 2024-07-24 00:00:00 |  |  | 9P
Caudillo | 2024-07-25 00:00:00 |  |  | 9P
Caudillo | 2024-07-26 00:00:00 |  |  | OFF
Caudillo | 2024-07-27 00:00:00 |  |  | OFF
Caudillo | 2024-07-28 00:00:00 |  |  | 9P
Caudillo | 2024-07-29 00:00:00 |  |  | 9P
Caudillo | 2024-07-30 00:00:00 |  |  | 9P
Caudillo | 2024-07-31 00:00:00 |  |  | 9P
Caudillo | 2024-08-01 00:00:00 |  |  | 9P
[NAME] | 2024-07-01 00:00:00 |  |  | 1P
[NAME] | 2024-07-02 00:00:00 |  |  | 1P
[NAME] | 2024-07-03 00:00:00 |  |  | 1P
[NAME] | 2024-07-04 00:00:00 |  |  | 1P
[NAME] | 2024-07-05 00:00:00 |  |  | 1P
[NAME] | 2024-07-06 00:00:00 |  |  | OFF
[NAME] | 2024-07-07 00:00:00 |  |  | OFF
[NAME] | 2024-07-08 00:00:00 |  |  | 1P
[NAME] | 2024-07-09 00:00:00 |  |  | 1P
[NAME] | 2024-07-10 00:00:00 |  |  | 1P
[NAME] | 2024-07-11 00:00:00 |  |  | 1P
[NAME] | 2024-07-12 00:00:00 |  |  | 1P
[NAME] | 2024-07-13 00:00:00 |  |  | OFF
[NAME] | 2024-07-14 00:00:00 |  |  | OFF
[NAME] | 2024-07-15 00:00:00 |  |  | 1P
[NAME] | 2024-07-16 00:00:00 |  |  | 1P
[NAME] | 2024-07-17 00:00:00 |  |  | 1P
[NAME] | 2024-07-18 00:00:00 |  |  | 1P
[NAME] | 2024-07-19 00:00:00 |  |  | 1P
[NAME] | 2024-07-20 00:00:00 |  |  | OFF
[NAME] | 2024-07-21 00:00:00 |  |  | OFF
[NAME] | 2024-07-22 00:00:00 |  |  | 1P
[NAME] | 2024-07-23 00:00:00 |  |  | 1P
[NAME] | 2024-07-24 00:00:00 |  |  | 1P
[NAME] | 2024-07-25 00:00:00 |  |  | 1P
[NAME] | 2024-07-26 00:00:00 |  |  | 1P
[NAME] | 2024-07-27 00:00:00 |  |  | OFF
[NAME] | 2024-07-28 00:00:00 |  |  | OFF
[NAME] | 2024-07-29 00:00:00 |  |  | 1P
[NAME] | 2024-07-30 00:00:00 |  |  | 1P
[NAME] | 2024-07-31 00:00:00 |  |  | 1P
[NAME] | 2024-08-01 00:00:00 |  |  | 1P
Greg | 2024-07-01 00:00:00 |  |  | 1P
Greg | 2024-07-02 00:00:00 |  |  | 1P
Greg | 2024-07-03 00:00:00 |  |  | 1P
Greg | 2024-07-04 00:00:00 |  |  | 1P
Greg | 2024-07-05 00:00:00 |  |  | 1P
Greg | 2024-07-06 00:00:00 |  |  | OFF
Greg | 2024-07-07 00:00:00 |  |  | OFF
Greg | 2024-07-08 00:00:00 |  |  | 1P
Greg | 2024-07-09 00:00:00 |  |  | 1P
Greg | 2024-07-10 00:00:00 |  |  | 1P
Greg | 2024-07-11 00:00:00 |  |  | 1P
Greg | 2024-07-12 00:00:00 |  |  | 1P
Greg | 2024-07-13 00:00:00 |  |  | OFF
Greg | 2024-07-14 00:00:00 |  |  | OFF
Greg | 2024-07-15 00:00:00 |  |  | 1P
Greg | 2024-07-16 00:00:00 |  |  | 1P
Greg | 2024-07-17 00:00:00 |  |  | 1P
Greg | 2024-07-18 00:00:00 |  |  | 1P
Greg | 2024-07-19 00:00:00 |  |  | 1P
Greg | 2024-07-20 00:00:00 |  |  | OFF
Greg | 2024-07-21 00:00:00 |  |  | OFF
Greg | 2024-07-22 00:00:00 |  |  | 1P
Greg | 2024-07-23 00:00:00 |  |  | 1P
Greg | 2024-07-24 00:00:00 |  |  | 1P
Greg | 2024-07-25 00:00:00 |  |  | 1P
Greg | 2024-07-26 00:00:00 |  |  | 1P
Greg | 2024-07-27 00:00:00 |  |  | OFF
Greg | 2024-07-28 00:00:00 |  |  | OFF
Greg | 2024-07-29 00:00:00 |  |  | 1P
Greg | 2024-07-30 00:00:00 |  |  | 1P
Greg | 2024-07-31 00:00:00 |  |  | 1P
Greg | 2024-08-01 00:00:00 |  |  | 1P