Spreadsheet: 856572d1705772564-complex-hours-sum-involving-semi-monthly-payperiod-and-monday-to-sunday-calendar-weeks-punches
Sheet: Punches

Date | Employee | Time In | Time Out | Total Time | Dec Time | Passes Validation?
2024-01-08 00:00:00 | [NAME] | 06:04:00 | 13:59:00
2024-01-08 00:00:00 | [NAME] | 10:43:00 | 13:19:00 | 2:36:00 | 2.6
2024-01-08 00:00:00 | [NAME] | 13:54:00 | 21:58:00 | 8:04:00 | 8.07
2024-01-08 00:00:00 | [NAME] | 21:48:00 | 06:14:00 | 8:26:00 | 8.43
2024-01-09 00:00:00 | [NAME] | 06:13:00 | 13:55:00 | 7:42:00 | 7.7
2024-01-09 00:00:00 | [NAME] | 09:00:00 | 15:00:00 | 6:00:00 | 6
2024-01-09 00:00:00 | [NAME] | 09:00:00 | 14:00:00 | 5:00:00 | 5
2024-01-09 00:00:00 | [NAME] | 13:50:00 | 22:02:00 | 8:12:00 | 8.2
2024-01-09 00:00:00 | [NAME] | 22:01:00 | 06:21:00 | 8:20:00 | 8.33
2024-01-10 00:00:00 | [NAME] | 06:10:00 | 14:01:00 | 7:51:00 | 7.85
2024-01-10 00:00:00 | [NAME] | 07:58:00 | 16:04:00 | 8:06:00 | 8.1
2024-01-10 00:00:00 | [NAME] | 09:00:00 | 16:30:00 | 7:30:00 | 7.5
2024-01-10 00:00:00 | [NAME] | 13:51:00 | 22:00:00 | 8:09:00 | 8.15
2024-01-10 00:00:00 | [NAME] | 22:01:00 | 06:19:00 | 8:18:00 | 8.3
2024-01-11 00:00:00 | [NAME] | 06:06:00 | 13:56:00 | 7:50:00 | 7.83
2024-01-11 00:00:00 | [NAME] | 07:56:00 | 15:59:00 | 8:03:00 | 8.05
2024-01-11 00:00:00 | [NAME] | 08:00:00 | 11:00:00 | 3:00:00 | 3
2024-01-11 00:00:00 | [NAME] | 13:55:00 | 21:59:00 | 8:04:00 | 8.07
2024-01-11 00:00:00 | [NAME] | 22:00:00 | 05:56:00 | 7:56:00 | 7.93
2024-01-12 00:00:00 | [NAME] | 05:42:00 | 13:57:00 | 8:15:00 | 8.25
2024-01-12 00:00:00 | [NAME] | 08:37:00 | 15:38:00 | 7:01:00 | 7.02
2024-01-12 00:00:00 | [NAME] | 10:00:00 | 13:30:00 | 3:30:00 | 3.5
2024-01-12 00:00:00 | [NAME] | 13:48:00 | 20:18:00 | 6:30:00 | 6.5
2024-01-12 00:00:00 | [NAME] | 15:59:00 | 22:00:00 | 6:01:00 | 6.02
2024-01-12 00:00:00 | [NAME] | 21:53:00 | 06:00:00 | 8:07:00 | 8.12
2024-01-13 00:00:00 | [NAME] | 05:43:00 | 14:14:00 | 8:31:00 | 8.52
2024-01-13 00:00:00 | [NAME] | 08:00:00 | 10:00:00 | 2:00:00 | 2
2024-01-13 00:00:00 | [NAME] | 08:08:00 | 15:02:00 | 6:54:00 | 6.9
2024-01-13 00:00:00 | [NAME] | 10:00:00 | 14:30:00 | 4:30:00 | 4.5
2024-01-13 00:00:00 | [NAME] | 13:53:00 | 20:03:00 | 6:10:00 | 6.17
2024-01-13 00:00:00 | [NAME] | 16:00:00 | 22:02:00 | 6:02:00 | 6.03
2024-01-13 00:00:00 | [NAME] | 21:45:00 | 06:00:00 | 8:15:00 | 8.25
2024-01-14 00:00:00 | [NAME] | 05:47:00 | 14:11:00 | 8:24:00 | 8.4
2024-01-14 00:00:00 | [NAME] | 07:59:00 | 16:01:00 | 8:02:00 | 8.03
2024-01-14 00:00:00 | [NAME] | 09:00:00 | 11:42:00 | 2:42:00 | 2.7
2024-01-14 00:00:00 | [NAME] | 13:50:00 | 22:01:00 | 8:11:00 | 8.18
2024-01-14 00:00:00 | [NAME] | 21:47:00 | 06:09:00 | 8:22:00 | 8.37
2024-01-15 00:00:00 | [NAME] | 05:59:00 | 14:02:00 | 8:03:00 | 8.05
2024-01-15 00:00:00 | [NAME] | 09:48:00 | 15:35:00 | 5:47:00 | 5.78
2024-01-15 00:00:00 | [NAME] | 10:00:00 | 17:45:00 | 7:45:00 | 7.75
2024-01-15 00:00:00 | [NAME] | 13:57:00 | 21:57:00 | 8:00:00 | 8
2024-01-15 00:00:00 | [NAME] | 21:47:00 | 06:05:00 | 8:18:00 | 8.3
2024-01-16 00:00:00 | [NAME] | 05:54:00 | 14:08:00 | 8:14:00 | 8.23
2024-01-16 00:00:00 | [NAME] | 07:58:00 | 08:13:00 | 0:15:00 | 0.25
2024-01-16 00:00:00 | [NAME] | 09:50:00 | 14:46:00 | 4:56:00 | 4.93
2024-01-16 00:00:00 | [NAME] | 14:00:00 | 22:00:00 | 8:00:00 | 8
2024-01-16 00:00:00 | [NAME] | 14:36:00 | 15:36:00 | 1:00:00 | 1
2024-01-16 00:00:00 | [NAME] | 22:00:00 | 06:13:00 | 8:13:00 | 8.22
2024-01-17 00:00:00 | [NAME] | 05:58:00 | 14:04:00 | 8:06:00 | 8.1
2024-01-17 00:00:00 | [NAME] | 07:57:00 | 16:05:00 | 8:08:00 | 8.13
2024-01-17 00:00:00 | [NAME] | 13:57:00 | 22:00:00 | 8:03:00 | 8.05
2024-01-17 00:00:00 | [NAME] | 22:00:00 | 06:09:00 | 8:09:00 | 8.15
2024-01-18 00:00:00 | [NAME] | 05:56:00 | 14:06:00 | 8:10:00 | 8.17
2024-01-18 00:00:00 | [NAME] | 07:58:00 | 16:35:00 | 8:37:00 | 8.62
2024-01-18 00:00:00 | [NAME] | 16:26:00 | 16:38:00 | 0:12:00 | 0.2
2024-01-18 00:00:00 | [NAME] | 16:34:00 | 22:02:00 | 5:28:00 | 5.47
2024-01-18 00:00:00 | [NAME] | 22:01:00 | 06:06:00 | 8:05:00 | 8.08
2024-01-19 00:00:00 | [NAME] | 05:55:00 | 14:04:00 | 8:09:00 | 8.15