Spreadsheet: 775306d1649005472-vlookup-w-multiple-criteria-attendance-report
Sheet: WEEKLY REVIEW

Clock  ID | Employee | Day | Clock  In | Clock  Out | Clock  Hours | Adjusted  Hours | Straight  Time | x1.50 | x2 | Vacation | ASAP  Bonus
03 |  | Thursday |  |  | 0 |  |  |  |  | 8 | 0
 |  | Friday |  |  | 0 |  |  |  |  | 8
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday | 2022-03-28 07:00:00 | 2022-03-28 16:00:00 | 8.5 |  |  |  |  | 0
 |  | Tuesday | 2022-03-29 07:21:25 | 2022-03-29 16:00:00 | 8.1431 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 06:54:30 | 2022-03-30 14:37:33 | 7.2175 |  |  |  |  | 0
04 |  | Thursday | 2022-03-24 09:54:20 | 2022-03-24 14:59:27 | 4.5853 |  |  |  |  | 0 | 4.75
 |  | Friday | 2022-03-25 05:40:12 | 2022-03-25 15:00:04 | 8.8311 |  |  |  |  | 0
 |  | Saturday | 2022-03-26 05:31:33 | 2022-03-26 11:13:19 | 5.6961
 |  | Sunday | 2022-03-27 12:09:59 | 2022-03-27 12:15:48 | 0
 |  | Monday | 2022-03-28 05:28:19 | 2022-03-28 15:03:19 | 9.0833 |  |  |  |  | 0
 |  | Tuesday | 2022-03-29 05:30:04 | 2022-03-29 15:00:34 | 9.0083 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 05:36:08 | 2022-03-30 15:00:19 | 8.9031 |  |  |  |  | 0
1 |  | Thursday | 2022-03-24 08:02:07 | 2022-03-24 14:30:19 | 5.97 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 0 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 0 |  |  |  |  | 8
 |  | Tuesday |  |  | 0 |  |  |  |  | 8
 |  | Wednesday |  |  | 0 |  |  |  |  | 8
13 |  | Thursday | 2022-03-24 06:56:43 | 2022-03-24 16:08:42 | 8.6997 |  |  |  |  | 0 | 0
 |  | Friday | 2022-03-25 05:43:15 | 2022-03-25 15:57:26 | 9.7364 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday | 2022-03-28 06:10:24 | 2022-03-28 17:33:19 | 10.8819 |  |  |  |  | 0
 |  | Tuesday | 2022-03-29 05:14:19 | 2022-03-29 16:08:13 | 10.3983 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 05:21:00 | 2022-03-30 15:59:27 | 10.1408 |  |  |  |  | 0
29 |  | Thursday | 2022-03-24 07:32:17 | 2022-03-24 16:00:43 | 7.9619 |  |  |  |  | 0 | 0
 |  | Friday | 2022-03-25 06:36:59 | 2022-03-25 15:57:59 | 8.85 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday | 2022-03-28 07:32:35 | 2022-03-28 15:59:36 | 7.9569 |  |  |  |  | 0
 |  | Tuesday | 2022-03-29 06:42:29 | 2022-03-29 15:58:03 | 8.7594 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 07:37:25 | 2022-03-30 15:57:49 | 7.84 |  |  |  |  | 0
38 |  | Thursday | 2022-03-24 05:30:27 | 2022-03-24 16:02:54 | 10.0408 |  |  |  |  | 0 | 6
 |  | Friday | 2022-03-25 05:23:29 | 2022-03-25 16:09:06 | 10.2603 |  |  |  |  | 0
 |  | Saturday | 2022-03-26 05:30:54 | 2022-03-26 11:30:36 | 5.995
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 0 |  |  |  |  | 0
 |  | Tuesday | 2022-03-29 05:29:09 | 2022-03-29 16:07:06 | 10.1325 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 05:28:28 | 2022-03-30 15:55:04 | 9.9433 |  |  |  |  | 0
42 |  | Thursday | 2022-03-24 06:29:29 | 2022-03-24 16:00:24 | 9.0086 |  |  |  |  | 0 | 0
 |  | Friday | 2022-03-25 07:28:45 | 2022-03-25 11:57:33 | 4.48 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday | 2022-03-28 07:28:11 | 2022-03-28 17:33:13 | 9.5839 |  |  |  |  | 0
 |  | Tuesday | 2022-03-29 06:23:36 | 2022-03-29 15:56:54 | 9.055 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 07:31:34 | 2022-03-30 15:58:26 | 7.9478 |  |  |  |  | 0
52 |  | Thursday | 2022-03-24 07:19:33 | 2022-03-24 15:58:24 | 8.1475 |  |  |  |  | 0 | 0
 |  | Friday | 2022-03-25 07:18:05 | 2022-03-25 15:56:38 | 8.1425 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday | 2022-03-28 07:19:26 | 2022-03-28 15:57:10 | 8.1289 |  |  |  |  | 0
 |  | Tuesday | 2022-03-29 07:11:54 | 2022-03-29 16:59:11 | 9.2881 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 07:21:15 | 2022-03-30 15:55:20 | 8.0681 |  |  |  |  | 0
53 |  | Thursday | 2022-03-24 05:28:57 | 2022-03-24 16:02:32 | 10.0597 |  |  |  |  | 0 | 4.75
 |  | Friday | 2022-03-25 06:43:33 | 2022-03-25 16:00:59 | 8.7742 |  |  |  |  | 0
 |  | Saturday | 2022-03-26 06:53:54 | 2022-03-26 10:50:53 | 3.9497
 |  | Sunday |  |  | 0
 |  | Monday | 2022-03-28 07:27:45 | 2022-03-28 15:58:57 | 8.02 |  |  |  |  | 0
 |  | Tuesday | 2022-03-29 07:00:29 | 2022-03-29 15:59:50 | 8.4919 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 07:13:34 | 2022-03-30 16:00:01 | 8.2739 |  |  |  |  | 0
54 |  | Thursday | 2022-03-24 07:31:02 | 2022-03-24 16:22:32 | 8.3583 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 0 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday | 2022-03-28 07:27:10 | 2022-03-28 16:02:35 | 8.0903 |  |  |  |  | 0
 |  | Tuesday | 2022-03-29 07:19:28 | 2022-03-29 16:59:29 | 9.1669 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 07:09:58 | 2022-03-30 17:13:31 | 9.5592 |  |  |  |  | 0
55 |  | Thursday | 2022-03-24 06:13:41 | 2022-03-24 15:17:49 | 8.5689 |  |  |  |  | 0 | 0
 |  | Friday | 2022-03-25 08:57:49 | 2022-03-25 15:58:20 | 6.5086 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday | 2022-03-28 07:12:18 | 2022-03-28 15:56:35 | 8.2381 |  |  |  |  | 0
 |  | Tuesday |  |  | 0 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 11:59:07 | 2022-03-30 16:57:19 | 4.47 |  |  |  |  | 0
57 |  | Thursday | 2022-03-24 06:37:34 | 2022-03-24 16:01:33 | 8.8997 |  |  |  |  | 0 | 0
 |  | Friday | 2022-03-25 07:32:20 | 2022-03-25 16:00:11 | 7.9642 |  |  |  |  | 0
 |  | Saturday | 2022-03-26 06:56:31 | 2022-03-26 11:11:48 | 4.2547
 |  | Sunday |  |  | 0
 |  | Monday | 2022-03-28 10:46:06 | 2022-03-28 16:02:05 | 4.7664 |  |  |  |  | 0
 |  | Tuesday |  |  | 0 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 07:35:40 | 2022-03-30 16:14:23 | 8.1453 |  |  |  |  | 0
63 |  | Thursday | 2022-03-24 05:36:19 | 2022-03-24 14:59:10 | 8.8808 |  |  |  |  | 0 | 0
 |  | Friday | 2022-03-25 05:30:16 | 2022-03-25 14:58:57 | 8.9781 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday | 2022-03-28 05:32:18 | 2022-03-28 14:59:07 | 8.9469 |  |  |  |  | 0
 |  | Tuesday | 2022-03-29 05:39:38 | 2022-03-29 14:58:44 | 8.8183 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 06:04:53 | 2022-03-30 14:58:38 | 8.3958 |  |  |  |  | 0
64 |  | Thursday | 2022-03-24 07:33:42 | 2022-03-24 16:00:06 | 7.94 |  |  |  |  | 0 | 0
 |  | Friday | 2022-03-25 10:09:17 | 2022-03-25 16:00:39 | 5.3561 |  |  |  |  | 0
 |  | Saturday | 2022-03-26 07:25:30 | 2022-03-26 11:08:49 | 3.7219
 |  | Sunday |  |  | 0
 |  | Monday | 2022-03-28 07:32:20 | 2022-03-28 15:58:30 | 7.9361 |  |  |  |  | 0
 |  | Tuesday | 2022-03-29 07:32:04 | 2022-03-29 16:00:27 | 7.9731 |  |  |  |  | 0
 |  | Wednesday | 2022-03-30 07:34:05 | 2022-03-30 11:55:55 | 4.3639 |  |  |  |  | 0
65 |  | Thursday | 2022-03-24 07:28:19 | 2022-03-24 15:43:17 | 7.7494 |  |  |  |  | 0 | 0
 |  | Friday | 2022-03-25 07:37:00 | 2022-03-25 09:33:29 | 1.9414 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 0 |  |  |  |  | 0
 |  | Tuesday |  |  | 0 |  |  |  |  | 0
 |  | Wednesday |  |  | 0 |  |  |  |  | 0