Spreadsheet: 806029d1669057769-daily-punch-audit-help-possible-answer-daily-in-out-audit-test-2
Sheet: punch

 |  | Employee Number |  |  | Punch Mode Description | Punch Date Time | Date | Time
 |  | 2054 |  |  | Out | 2022-06-20 22:57:00
 |  | 2054 |  |  | In | 2022-06-21 10:56:00
 |  | 2054 |  |  | Out | 2022-06-21 22:27:00
 |  | 2054 |  |  | In | 2022-06-23 11:48:00
 |  | 2054 |  |  | Out | 2022-06-23 22:30:00
 |  | 2054 |  |  | In | 2022-06-24 10:02:00
 |  | 2054 |  |  | Out | 2022-06-24 22:34:00
 |  | 2054 |  |  | In | 2022-06-25 08:03:00
 |  | 2054 |  |  | Out | 2022-06-25 19:34:00
 |  | 2054 |  |  | In | 2022-06-27 09:57:00
 |  | 2054 |  |  | Out | 2022-06-27 22:40:00
 |  | 2054 |  |  | In | 2022-06-28 10:13:00
 |  | 2054 |  |  | Out | 2022-06-28 22:37:00
 |  | 2054 |  |  | In | 2022-06-29 10:26:00
 |  | 2054 |  |  | Out | 2022-06-29 22:41:00
 |  | 2054 |  |  | In | 2022-06-20 10:00:00
 |  | 2054 |  |  | Out | 2022-06-30 22:43:00
 |  | 2054 |  |  | In | 2022-07-01 10:24:00
 |  | 2054 |  |  | Out | 2022-07-01 22:37:00
 |  | 2054 |  |  | In | 2022-07-02 08:10:00
 |  | 2054 |  |  | Out | 2022-07-02 19:38:00
 |  | 2054 |  |  | In | 2022-07-04 06:00:00
 |  | 2054 |  |  | Out | 2022-07-04 11:48:00
 |  | 2054 |  |  | In | 2022-07-05 11:31:00
 |  | 2054 |  |  | Out | 2022-07-05 20:02:00
 |  | 2054 |  |  | In | 2022-07-06 14:05:00
 |  | 2054 |  |  | In | 2022-07-07 14:00:00
 |  | 2054 |  |  | Out | 2022-07-07 22:37:00
 |  | 2054 |  |  | In | 2022-07-11 12:00:00
 |  | 2054 |  |  | Out | 2022-07-11 22:40:00
 |  | 2054 |  |  | In | 2022-07-12 12:46:00
 |  | 2054 |  |  | Out | 2022-07-12 22:30:00
 |  | 2054 |  |  | In | 2022-07-14 11:45:00
 |  | 2054 |  |  | Out | 2022-07-14 22:33:00
 |  | 2054 |  |  | In | 2022-07-18 12:09:00
 |  | 2054 |  |  | In | 2022-07-19 11:49:00
 |  | 2054 |  |  | Out | 2022-07-19 22:58:00
 |  | 2054 |  |  | Out | 2022-07-20 22:50:00
 |  | 2054 |  |  | In | 2022-07-21 12:10:00
 |  | 2054 |  |  | Out | 2022-07-21 22:43:00
 |  | 2054 |  |  | In | 2022-07-22 12:01:00
 |  | 2054 |  |  | Out | 2022-07-22 19:30:00
 |  | 2054 |  |  | In | 2022-07-25 14:01:00
 |  | 2054 |  |  | Out | 2022-07-25 22:33:00
 |  | 2054 |  |  | Out | 2022-07-26 22:37:00
 |  | 2054 |  |  | In | 2022-07-27 14:04:00
 |  | 2054 |  |  | In | 2022-07-28 14:04:00
 |  | 2054 |  |  | In | 2022-07-29 11:05:00
 |  | 2054 |  |  | Out | 2022-07-29 21:14:00
 |  | 2054 |  |  | In | 2022-08-01 14:08:00
 |  | 2054 |  |  | Out | 2022-08-01 20:19:00
 |  | 2054 |  |  | Out | 2022-08-03 22:33:00
 |  | 2054 |  |  | In | 2022-08-04 14:24:00
 |  | 2054 |  |  | Out | 2022-08-04 22:36:00
 |  | 2054 |  |  | In | 2022-08-05 09:54:00
 |  | 2054 |  |  | In | 2022-08-06 08:23:00
 |  | 2054 |  |  | Out | 2022-07-28 22:35:00
 |  | 2054 |  |  | In | 2022-08-08 13:44:00
 |  | 2054 |  |  | Out | 2022-08-08 22:49:00
 |  | 2054 |  |  | Out | 2022-07-27 22:35:00
 |  | 2054 |  |  | In | 2022-07-26 14:05:00
 |  | 2054 |  |  | Out | 2022-07-23 19:53:00
 |  | 2054 |  |  | Out | 2022-08-10 23:05:00
 |  | 2054 |  |  | In | 2022-08-11 10:12:00
 |  | 2054 |  |  | Out | 2022-08-11 22:44:00
 |  | 2054 |  |  | Out | 2022-08-12 19:34:00
 |  | 2054 |  |  | In | 2022-08-15 09:59:00
 |  | 2054 |  |  | Out | 2022-08-15 22:30:00
 |  | 2054 |  |  | In | 2022-08-12 07:00:00
 |  | 2054 |  |  | In | 2022-08-16 10:17:00
 |  | 2054 |  |  | Out | 2022-08-16 22:39:00
 |  | 2054 |  |  | In | 2022-08-18 10:16:00
 |  | 2054 |  |  | In | 2022-07-23 10:59:00
 |  | 2054 |  |  | In | 2022-07-20 12:12:00
 |  | 2054 |  |  | Out | 2022-07-18 22:40:00
 |  | 2054 |  |  | In | 2022-08-20 09:05:00
 |  | 2054 |  |  | In | 2022-08-22 10:36:00
 |  | 2054 |  |  | Out | 2022-08-22 22:38:00
 |  | 2054 |  |  | In | 2022-08-23 10:37:00
 |  | 2054 |  |  | Out | 2022-08-23 22:42:00
 |  | 2054 |  |  | Out | 2022-08-24 22:40:00
 |  | 2054 |  |  | In | 2022-08-25 10:33:00
 |  | 2054 |  |  | Out | 2022-08-25 22:53:00
 |  | 2054 |  |  | In | 2022-08-26 10:11:00
 |  | 2054 |  |  | Out | 2022-08-26 21:05:00
 |  | 2054 |  |  | In | 2022-08-29 06:48:00
 |  | 2054 |  |  | Out | 2022-08-20 19:30:00
 |  | 2054 |  |  | Out | 2022-08-29 19:30:00
 |  | 2054 |  |  | In | 2022-08-30 07:00:00
 |  | 2054 |  |  | Out | 2022-08-30 19:30:00
 |  | 2054 |  |  | In | 2022-08-31 07:13:00
 |  | 2054 |  |  | Out | 2022-08-31 19:43:00
 |  | 2054 |  |  | In | 2022-09-01 09:08:00
 |  | 2054 |  |  | In | 2022-09-02 07:44:00
 |  | 2054 |  |  | Out | 2022-07-13 22:39:00
 |  | 2054 |  |  | Out | 2022-09-02 19:30:00
 |  | 2054 |  |  | In | 2022-09-05 07:24:00
 |  | 2054 |  |  | Out | 2022-09-05 09:45:00
 |  | 2054 |  |  | In | 2022-09-06 06:51:00
 |  | 2054 |  |  | Out | 2022-09-06 19:30:00
 |  | 2054 |  |  | In | 2022-09-07 07:49:00
 |  | 2054 |  |  | Out | 2022-09-07 19:30:00
 |  | 2054 |  |  | In | 2022-09-08 07:09:00
 |  | 2054 |  |  | Out | 2022-09-08 19:34:00
 |  | 2054 |  |  | In | 2022-09-09 08:18:00
 |  | 2054 |  |  | Out | 2022-09-09 17:09:00
 |  | 2054 |  |  | In | 2022-09-13 07:01:00
 |  | 2054 |  |  | Out | 2022-09-13 19:35:00
 |  | 2054 |  |  | In | 2022-09-14 07:41:00
 |  | 2054 |  |  | Out | 2022-09-01 19:30:00
 |  | 2054 |  |  | Out | 2022-09-14 19:31:00
 |  | 2054 |  |  | In | 2022-09-16 07:01:00
 |  | 2054 |  |  | Out | 2022-09-16 18:47:00
 |  | 2054 |  |  | In | 2022-07-13 12:11:00
 |  | 2054 |  |  | Out | 2022-07-08 21:16:00
 |  | 2054 |  |  | In | 2022-07-08 13:55:00
 |  | 2054 |  |  | Out | 2022-07-06 22:39:00
 |  | 2054 |  |  | In | 2022-06-30 10:13:00
 |  | 2054 |  |  | Out | 2022-08-06 19:33:00
 |  | 2054 |  |  | Out | 2022-08-05 22:30:00
 |  | 2054 |  |  | In | 2022-08-03 13:54:00
 |  | 2054 |  |  | In | 2022-08-09 09:48:00
 |  | 2054 |  |  | Out | 2022-08-09 22:51:00
 |  | 2054 |  |  | In | 2022-08-10 10:08:00
 |  | 2054 |  |  | Out | 2022-08-18 22:42:00
 |  | 2054 |  |  | In | 2022-08-19 10:01:00
 |  | 2054 |  |  | Out | 2022-08-19 23:06:00
 |  | 2054 |  |  | In | 2022-08-24 10:12:00
 |  | 2054 |  |  | In | 2022-09-19 08:42:00
 |  | 2054 |  |  | Out | 2022-09-19 19:30:00
 |  | 2054 |  |  | In | 2022-09-20 08:57:00
 |  | 2054 |  |  | Out | 2022-09-20 19:30:00
 |  | 2054 |  |  | In | 2022-09-21 07:32:00
 |  | 2054 |  |  | Out | 2022-09-21 19:30:00
 |  | 2054 |  |  | In | 2022-09-22 07:22:00
 |  | 2054 |  |  | Out | 2022-09-22 19:30:00
 |  | 2054 |  |  | In | 2022-09-23 07:04:00
 |  | 2054 |  |  | Out | 2022-09-23 17:30:00
 |  | 2054 |  |  | In | 2022-09-24 07:49:00
 |  | 2054 |  |  | Out | 2022-09-24 17:40:00
 |  | 2054 |  |  | In | 2022-09-26 07:07:00
 |  | 2054 |  |  | Out | 2022-09-26 17:30:00
 |  | 2054 |  |  | In | 2022-09-27 07:06:00
 |  | 2054 |  |  | Out | 2022-09-27 17:32:00
 |  | 2054 |  |  | In | 2022-09-28 07:16:00
 |  | 2054 |  |  | Out | 2022-09-28 17:31:00
 |  | 2054 |  |  | In | 2022-09-29 07:06:00
 |  | 2054 |  |  | Out | 2022-09-29 15:37:00
 |  | 2054 |  |  | In | 2022-09-30 07:10:00
 |  | 2054 |  |  | Out | 2022-09-30 15:34:00
 |  | 2054 |  |  | In | 2022-10-04 07:03:00
 |  | 2054 |  |  | Out | 2022-10-04 15:34:00
 |  | 2054 |  |  | In | 2022-10-05 07:12:00
 |  | 2054 |  |  | Out | 2022-10-05 15:42:00
 |  | 2054 |  |  | In | 2022-10-06 07:09:00
 |  | 2054 |  |  | Out | 2022-10-06 15:43:00
 |  | 2054 |  |  | In | 2022-10-07 08:44:00
 |  | 2054 |  |  | Out | 2022-10-07 16:08:00
 |  | 2054 |  |  | In | 2022-10-11 07:01:00
 |  | 2054 |  |  | Out | 2022-10-11 15:33:00
 |  | 2054 |  |  | In | 2022-10-12 07:07:00
 |  | 2054 |  |  | Out | 2022-10-12 15:37:00
 |  | 2054 |  |  | In | 2022-10-13 07:05:00
 |  | 2054 |  |  | Out | 2022-10-13 15:41:00
 |  | 2054 |  |  | In | 2022-10-18 07:40:00
 |  | 2054 |  |  | Out | 2022-10-18 15:56:00
 |  | 2054 |  |  | In | 2022-10-19 06:57:00
 |  | 2054 |  |  | Out | 2022-10-20 15:55:00
 |  | 2054 |  |  | In | 2022-10-21 07:17:00
 |  | 2054 |  |  | Out | 2022-10-21 15:44:00
 |  | 2054 |  |  | In | 2022-10-25 07:25:00
 |  | 2054 |  |  | Out | 2022-10-25 15:54:00
 |  | 2054 |  |  | In | 2022-10-26 07:08:00
 |  | 2054 |  |  | Out | 2022-10-26 15:46:00
 |  | 2054 |  |  | In | 2022-10-27 07:24:00
 |  | 2054 |  |  | Out | 2022-10-27 15:52:00
 |  | 2054 |  |  | In | 2022-10-28 06:59:00
 |  | 2054 |  |  | Out | 2022-10-28 15:40:00
 |  | 2054 |  |  | In | 2022-11-01 07:17:00
 |  | 2054 |  |  | Out | 2022-11-01 15:30:00
 |  | 2054 |  |  | In | 2022-11-02 07:06:00
 |  | 2054 |  |  | In | 2022-10-20 07:25:00
 |  | 2054 |  |  | Out | 2022-10-19 15:31:00
 |  | 2054 |  |  | Out | 2022-11-02 15:35:00
 |  | 2054 |  |  | In | 2022-11-03 07:11:00
 |  | 2054 |  |  | Out | 2022-11-03 12:30:00
 |  | 2054 |  |  | In | 2022-11-04 07:27:00
 |  | 2054 |  |  | Out | 2022-11-04 15:56:00
 |  | 2054 |  |  | In | 2022-11-07 06:55:00
 |  | 2054 |  |  | Out | 2022-11-07 15:32:00
 |  | 2054 |  |  | In | 2022-11-08 07:38:00
 |  | 2054 |  |  | Out | 2022-11-08 15:54:00
 |  | 2054 |  |  | In | 2022-11-09 06:54:00
 |  | 2054 |  |  | Out | 2022-11-09 15:39:00
 |  | 2054 |  |  | In | 2022-11-10 07:09:00
 |  | 2054 |  |  | Out | 2022-11-10 13:01:00
 |  | 2054 |  |  | In | 2022-11-15 06:52:00
 |  | 2054 |  |  | Out | 2022-11-15 15:38:00
 |  | 2054 |  |  | In | 2022-11-16 06:52:00
 |  | 2054 |  |  | Out | 2022-11-16 17:59:00
 |  | 2054 |  |  | In | 2022-11-17 07:00:00
 |  | 2054 |  |  | In | 2022-11-18 06:54:00
 |  | 2054 |  |  | Out | 2022-11-18 18:01:00
 |  | 2054 |  |  | In | 2022-11-19 06:46:00
 |  | 2054 |  |  | Out | 2022-11-19 19:52:00
 |  | 2054 |  |  | In | 2022-11-21 07:56:00