Spreadsheet: 775306d1649005472-vlookup-w-multiple-criteria-attendance-report
Sheet: RAW DATA

Clock ID | Employee | Clock In | Clock Out | Clock Hours | Review Status |  |  | Day of the Week
03 | [NAME] | 2022-03-28 07:00:00 | 2022-03-28 16:00:00 |  | 8.5 | Not Approved
03 | [NAME] | 2022-03-29 07:21:25 | 2022-03-29 16:00:00 |  | 8.1431 | Not Approved
03 | [NAME] | 2022-03-30 06:54:30 | 2022-03-30 14:37:33 |  | 7.2175 | Not Approved
23.8606
04 | [NAME] | 2022-03-24 09:54:20 | 2022-03-24 14:59:27 |  | 4.5853 | Not Approved
04 | [NAME] | 2022-03-25 05:40:12 | 2022-03-25 15:00:04 |  | 8.8311 | Not Approved
04 | [NAME] | 2022-03-26 05:31:33 | 2022-03-26 11:13:19 |  | 5.6961 | Not Approved
04 | [NAME] | 2022-03-27 12:09:59 | 2022-03-27 12:15:48 |  | 0 | Not Approved
04 | [NAME] | 2022-03-28 05:28:19 | 2022-03-28 15:03:19 |  | 9.0833 | Not Approved
04 | [NAME] | 2022-03-29 05:30:04 | 2022-03-29 15:00:34 |  | 9.0083 | Not Approved
04 | [NAME] | 2022-03-30 05:36:08 | 2022-03-30 15:00:19 |  | 8.9031 | Not Approved
46.1072
1 | [NAME] | 2022-03-24 08:02:07 | 2022-03-24 14:30:19 |  | 5.97 | Not Approved
5.97
13 | [NAME] | 2022-03-24 06:56:43 | 2022-03-24 16:08:42 |  | 8.6997 | Not Approved
13 | [NAME] | 2022-03-25 05:43:15 | 2022-03-25 15:57:26 |  | 9.7364 | Not Approved
13 | [NAME] | 2022-03-28 06:10:24 | 2022-03-28 17:33:19 |  | 10.8819 | Not Approved
13 | [NAME] | 2022-03-29 05:14:19 | 2022-03-29 16:08:13 |  | 10.3983 | Not Approved
13 | [NAME] | 2022-03-30 05:21:00 | 2022-03-30 15:59:27 |  | 10.1408 | Not Approved
49.8571
29 | [NAME] | 2022-03-24 07:32:17 | 2022-03-24 16:00:43 |  | 7.9619 | Not Approved
29 | [NAME] | 2022-03-25 06:36:59 | 2022-03-25 15:57:59 |  | 8.85 | Not Approved
29 | [NAME] | 2022-03-28 07:32:35 | 2022-03-28 15:59:36 |  | 7.9569 | Not Approved
29 | [NAME] | 2022-03-29 06:42:29 | 2022-03-29 15:58:03 |  | 8.7594 | Not Approved
29 | [NAME] | 2022-03-30 07:37:25 | 2022-03-30 15:57:49 |  | 7.84 | Not Approved
41.3682
38 | [NAME] | 2022-03-24 05:30:27 | 2022-03-24 16:02:54 |  | 10.0408 | Not Approved
38 | [NAME] | 2022-03-25 05:23:29 | 2022-03-25 16:09:06 |  | 10.2603 | Not Approved
38 | [NAME] | 2022-03-26 05:30:54 | 2022-03-26 11:30:36 |  | 5.995 | Not Approved
38 | [NAME] | 2022-03-29 05:29:09 | 2022-03-29 16:07:06 |  | 10.1325 | Not Approved
38 | [NAME] | 2022-03-30 05:28:28 | 2022-03-30 15:55:04 |  | 9.9433 | Not Approved
46.3719
42 | [NAME] | 2022-03-24 06:29:29 | 2022-03-24 16:00:24 |  | 9.0086 | Not Approved
42 | [NAME] | 2022-03-25 07:28:45 | 2022-03-25 11:57:33 |  | 4.48 | Not Approved
42 | [NAME] | 2022-03-28 07:28:11 | 2022-03-28 17:33:13 |  | 9.5839 | Not Approved
42 | [NAME] | 2022-03-29 06:23:36 | 2022-03-29 15:56:54 |  | 9.055 | Not Approved
42 | [NAME] | 2022-03-30 07:31:34 | 2022-03-30 15:58:26 |  | 7.9478 | Not Approved
40.0753
52 | [NAME] | 2022-03-24 07:19:33 | 2022-03-24 15:58:24 |  | 8.1475 | Not Approved
52 | [NAME] | 2022-03-25 07:18:05 | 2022-03-25 15:56:38 |  | 8.1425 | Not Approved
52 | [NAME] | 2022-03-28 07:19:26 | 2022-03-28 15:57:10 |  | 8.1289 | Not Approved
52 | [NAME] | 2022-03-29 07:11:54 | 2022-03-29 16:59:11 |  | 9.2881 | Not Approved
52 | [NAME] | 2022-03-30 07:21:15 | 2022-03-30 15:55:20 |  | 8.0681 | Not Approved
41.7751
53 | [NAME] | 2022-03-24 05:28:57 | 2022-03-24 16:02:32 |  | 10.0597 | Not Approved
53 | [NAME] | 2022-03-25 06:43:33 | 2022-03-25 16:00:59 |  | 8.7742 | Not Approved
53 | [NAME] | 2022-03-26 06:53:54 | 2022-03-26 10:50:53 |  | 3.9497 | Not Approved
53 | [NAME] | 2022-03-28 07:27:45 | 2022-03-28 15:58:57 |  | 8.02 | Not Approved
53 | [NAME] | 2022-03-29 07:00:29 | 2022-03-29 15:59:50 |  | 8.4919 | Not Approved
53 | [NAME] | 2022-03-30 07:13:34 | 2022-03-30 16:00:01 |  | 8.2739 | Not Approved
47.5694
54 | [NAME] | 2022-03-24 07:31:02 | 2022-03-24 16:22:32 |  | 8.3583 | Not Approved
54 | [NAME] | 2022-03-28 07:27:10 | 2022-03-28 16:02:35 |  | 8.0903 | Not Approved
54 | [NAME] | 2022-03-29 07:19:28 | 2022-03-29 16:59:29 |  | 9.1669 | Not Approved
54 | [NAME] | 2022-03-30 07:09:58 | 2022-03-30 17:13:31 |  | 9.5592 | Not Approved
35.1747
55 | [NAME] | 2022-03-24 06:13:41 | 2022-03-24 15:17:49 |  | 8.5689 | Not Approved
55 | [NAME] | 2022-03-25 08:57:49 | 2022-03-25 15:58:20 |  | 6.5086 | Not Approved
55 | [NAME] | 2022-03-28 07:12:18 | 2022-03-28 15:56:35 |  | 8.2381 | Not Approved
55 | [NAME] | 2022-03-30 11:59:07 | 2022-03-30 16:57:19 |  | 4.47 | Not Approved
27.7856
57 | [NAME] | 2022-03-24 06:37:34 | 2022-03-24 16:01:33 |  | 8.8997 | Not Approved
57 | [NAME] | 2022-03-25 07:32:20 | 2022-03-25 16:00:11 |  | 7.9642 | Not Approved
57 | [NAME] | 2022-03-26 06:56:31 | 2022-03-26 11:11:48 |  | 4.2547 | Not Approved
57 | [NAME] | 2022-03-28 10:46:06 | 2022-03-28 16:02:05 |  | 4.7664 | Not Approved
57 | [NAME] | 2022-03-30 07:35:40 | 2022-03-30 16:14:23 |  | 8.1453 | Not Approved
34.0303
63 | [NAME] | 2022-03-24 05:36:19 | 2022-03-24 14:59:10 |  | 8.8808 | Not Approved
63 | [NAME] | 2022-03-25 05:30:16 | 2022-03-25 14:58:57 |  | 8.9781 | Not Approved
63 | [NAME] | 2022-03-28 05:32:18 | 2022-03-28 14:59:07 |  | 8.9469 | Not Approved
63 | [NAME] | 2022-03-29 05:39:38 | 2022-03-29 14:58:44 |  | 8.8183 | Not Approved
63 | [NAME] | 2022-03-30 06:04:53 | 2022-03-30 14:58:38 |  | 8.3958 | Not Approved
44.0199
64 | [NAME] | 2022-03-24 07:33:42 | 2022-03-24 16:00:06 |  | 7.94 | Not Approved
64 | [NAME] | 2022-03-25 10:09:17 | 2022-03-25 16:00:39 |  | 5.3561 | Not Approved
64 | [NAME] | 2022-03-26 07:25:30 | 2022-03-26 11:08:49 |  | 3.7219 | Not Approved
64 | [NAME] | 2022-03-28 07:32:20 | 2022-03-28 15:58:30 |  | 7.9361 | Not Approved
64 | [NAME] | 2022-03-29 07:32:04 | 2022-03-29 16:00:27 |  | 7.9731 | Not Approved
64 | [NAME] | 2022-03-30 07:34:05 | 2022-03-30 11:55:55 |  | 4.3639 | Not Approved
37.2911
65 | [NAME] | 2022-03-24 07:28:19 | 2022-03-24 15:43:17 |  | 7.7494 | Not Approved
65 | [NAME] | 2022-03-25 07:37:00 | 2022-03-25 09:33:29 |  | 1.9414 | Not Approved
9.6908
530.9472
Page -1 of 1