Spreadsheet: 806204d1669159686-audit-date-punch-type-lookup-time-test-ag
Sheet: Punch Export

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