Spreadsheet: 731625d1620462784-multi-criteria-vlookup-daily-in-out-audit-ans
Sheet: punch

Employee Number |  |  |  |  |  | Actual Date Time | Punch Date Time | Create Date Time |  | Mode
1894 |  |  |  |  |  | 2021-05-03 14:51:00 | 2021-05-03 14:51:00 | 5/3/2021 7:51:59 PM |  | In
1894 |  |  |  |  |  | 2021-05-03 23:31:00 | 2021-05-03 23:31:00 | 5/4/2021 4:31:21 AM |  | Out
1894 |  |  |  |  |  | 2021-05-04 14:53:00 | 2021-05-04 14:53:00 | 5/4/2021 7:54:12 PM |  | In
1894 |  |  |  |  |  | 2021-05-04 23:31:00 | 2021-05-04 23:31:00 | 5/5/2021 4:31:49 AM |  | Out
1894 |  |  |  |  |  | 2021-05-05 14:58:00 | 2021-05-05 14:58:00 | 5/5/2021 7:58:47 PM |  | In
1894 |  |  |  |  |  | 2021-05-05 23:37:00 | 2021-05-05 23:37:00 | 5/6/2021 4:38:23 AM |  | Out
1894 |  |  |  |  |  | 2021-05-06 15:05:00 | 2021-05-06 15:05:00 | 5/6/2021 8:05:23 PM |  | In
1894 |  |  |  |  |  | 2021-05-06 23:34:00 | 2021-05-06 23:34:00 | 5/7/2021 4:34:40 AM |  | Out
1894 |  |  |  |  |  | 2021-05-07 14:57:00 | 2021-05-07 14:57:00 | 5/7/2021 7:57:41 PM |  | In
1865 |  |  |  |  |  | 2021-05-04 06:24:00 | 2021-05-04 06:24:00 | 5/4/2021 11:24:57 AM |  | In
1865 |  |  |  |  |  | 2021-05-04 14:27:00 | 2021-05-04 14:27:00 | 5/4/2021 7:27:49 PM |  | Out
1865 |  |  |  |  |  | 2021-05-05 06:24:00 | 2021-05-05 06:24:00 | 5/5/2021 11:24:59 AM |  | In
1865 |  |  |  |  |  | 2021-05-05 14:57:00 | 2021-05-05 14:57:00 | 5/5/2021 7:57:49 PM |  | Out
1865 |  |  |  |  |  | 2021-05-06 06:25:00 | 2021-05-06 06:25:00 | 5/6/2021 11:25:44 AM |  | In
1865 |  |  |  |  |  | 2021-05-06 14:59:00 | 2021-05-06 14:59:00 | 5/6/2021 7:59:54 PM |  | Out
1865 |  |  |  |  |  | 2021-05-07 05:20:00 | 2021-05-07 05:20:00 | 5/7/2021 10:20:26 AM |  | In
1865 |  |  |  |  |  | 2021-05-07 14:36:00 | 2021-05-07 14:36:00 | 5/7/2021 7:37:23 PM |  | Out
1910 |  |  |  |  |  | 2021-05-03 05:24:00 | 2021-05-03 05:24:00 | 5/3/2021 10:24:46 AM |  | In
1910 |  |  |  |  |  | 2021-05-03 14:00:00 | 2021-05-03 14:00:00 | 5/3/2021 7:02:21 PM |  | Out
1910 |  |  |  |  |  | 2021-05-04 05:25:00 | 2021-05-04 05:25:00 | 5/4/2021 10:25:29 AM |  | In
1910 |  |  |  |  |  | 2021-05-04 14:00:00 | 2021-05-04 14:00:00 | 5/4/2021 7:00:42 PM |  | Out
1910 |  |  |  |  |  | 2021-05-05 05:25:00 | 2021-05-05 05:25:00 | 5/5/2021 10:25:59 AM |  | In
1910 |  |  |  |  |  | 2021-05-05 14:00:00 | 2021-05-05 14:00:00 | 5/5/2021 7:00:25 PM |  | Out
1910 |  |  |  |  |  | 2021-05-06 14:02:00 | 2021-05-06 14:02:00 | 5/6/2021 7:02:31 PM |  | Out
1910 |  |  |  |  |  | 2021-05-07 05:25:00 | 2021-05-07 05:25:00 | 5/7/2021 10:26:19 AM |  | In
1910 |  |  |  |  |  | 2021-05-07 14:00:00 | 2021-05-07 14:00:00 | 5/7/2021 7:01:06 PM |  | Out
1792 |  |  |  |  |  | 2021-05-03 05:27:00 | 2021-05-03 05:27:00 | 5/3/2021 10:27:58 AM |  | In
1792 |  |  |  |  |  | 2021-05-03 14:02:00 | 2021-05-03 14:02:00 | 5/3/2021 7:03:59 PM |  | Out
1792 |  |  |  |  |  | 2021-05-04 05:28:00 | 2021-05-04 05:28:00 | 5/4/2021 [NAME] |  | In
1792 |  |  |  |  |  | 2021-05-04 14:23:00 | 2021-05-04 14:23:00 | 5/4/2021 7:24:01 PM |  | Out
1792 |  |  |  |  |  | 2021-05-05 10:41:00 | 2021-05-05 10:41:00 | 5/5/2021 3:41:59 PM |  | In
1792 |  |  |  |  |  | 2021-05-05 20:01:00 | 2021-05-05 20:01:00 | 5/6/2021 1:02:04 AM |  | Out
1792 |  |  |  |  |  | 2021-05-06 10:53:00 | 2021-05-06 10:53:00 | 5/6/2021 3:53:48 PM |  | In
1792 |  |  |  |  |  | 2021-05-06 21:37:00 | 2021-05-06 21:37:00 | 5/7/2021 2:38:11 AM |  | Out
1792 |  |  |  |  |  | 2021-05-07 10:44:00 | 2021-05-07 10:44:00 | 5/7/2021 3:44:38 PM |  | In
1804 |  |  |  |  |  | 2021-05-03 05:35:00 | 2021-05-03 05:35:00 | 5/3/2021 10:35:45 AM |  | In
1804 |  |  |  |  |  | 2021-05-03 15:30:00 | 2021-05-03 15:30:00 | 5/3/2021 8:31:02 PM |  | Out
1804 |  |  |  |  |  | 2021-05-04 05:33:00 | 2021-05-04 05:33:00 | 5/4/2021 10:33:45 AM |  | In
1804 |  |  |  |  |  | 2021-05-04 14:17:00 | 2021-05-04 14:17:00 | 5/4/2021 7:17:37 PM |  | Out
1804 |  |  |  |  |  | 2021-05-05 05:35:00 | 2021-05-05 05:35:00 | 5/5/2021 10:36:06 AM |  | In
1804 |  |  |  |  |  | 2021-05-05 14:21:00 | 2021-05-05 14:21:00 | 5/5/2021 7:21:31 PM |  | Out
1804 |  |  |  |  |  | 2021-05-06 05:39:00 | 2021-05-06 05:39:00 | 5/6/2021 10:39:46 AM |  | In
1804 |  |  |  |  |  | 2021-05-06 14:21:00 | 2021-05-06 14:21:00 | 5/6/2021 7:21:54 PM |  | Out
1804 |  |  |  |  |  | 2021-05-07 05:37:00 | 2021-05-07 05:37:00 | 5/7/2021 10:38:05 AM |  | In
1804 |  |  |  |  |  | 2021-05-07 14:51:00 | 2021-05-07 14:51:00 | 5/7/2021 7:51:27 PM |  | Out
1815 |  |  |  |  |  | 2021-05-03 05:44:00 | 2021-05-03 05:44:00 | 5/3/2021 10:44:19 AM |  | In
1815 |  |  |  |  |  | 2021-05-03 15:30:00 | 2021-05-03 15:30:00 | 5/3/2021 8:32:17 PM |  | Out
1815 |  |  |  |  |  | 2021-05-04 05:34:00 | 2021-05-04 05:34:00 | 5/4/2021 10:34:32 AM |  | In
1815 |  |  |  |  |  | 2021-05-04 15:36:00 | 2021-05-04 15:36:00 | 5/4/2021 8:36:45 PM |  | Out
1815 |  |  |  |  |  | 2021-05-05 05:34:00 | 2021-05-05 05:34:00 | 5/5/2021 10:34:32 AM |  | In
1815 |  |  |  |  |  | 2021-05-05 15:43:00 | 2021-05-05 15:43:00 | 5/5/2021 8:43:31 PM |  | Out
1815 |  |  |  |  |  | 2021-05-06 05:35:00 | 2021-05-06 05:35:00 | 5/6/2021 10:36:08 AM |  | In
1815 |  |  |  |  |  | 2021-05-06 15:39:00 | 2021-05-06 15:39:00 | 5/6/2021 8:40:03 PM |  | Out
1815 |  |  |  |  |  | 2021-05-07 05:34:00 | 2021-05-07 05:34:00 | 5/7/2021 10:35:11 AM |  | In
1815 |  |  |  |  |  | 2021-05-07 15:00:00 | 2021-05-07 15:00:00 | 5/7/2021 8:00:45 PM |  | Out