Spreadsheet: 775311d1649008550-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 |  |  | 8.5 |  |  |  |  | 0
 |  | Tuesday |  |  | 8.1431 |  |  |  |  | 0
 |  | Wednesday |  |  | 7.2175 |  |  |  |  | 0
04 |  | Thursday |  |  | 4.5853 |  |  |  |  | 0 | 4.75
 |  | Friday |  |  | 8.8311 |  |  |  |  | 0
 |  | Saturday |  |  | 5.6961
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 9.0833 |  |  |  |  | 0
 |  | Tuesday |  |  | 9.0083 |  |  |  |  | 0
 |  | Wednesday |  |  | 8.9031 |  |  |  |  | 0
1 |  | Thursday |  |  | 5.97 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 0 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 0 |  |  |  |  | 8
 |  | Tuesday |  |  | 0 |  |  |  |  | 8
 |  | Wednesday |  |  | 0 |  |  |  |  | 8
13 |  | Thursday |  |  | 8.6997 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 9.7364 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 10.8819 |  |  |  |  | 0
 |  | Tuesday |  |  | 10.3983 |  |  |  |  | 0
 |  | Wednesday |  |  | 10.1408 |  |  |  |  | 0
29 |  | Thursday |  |  | 7.9619 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 8.85 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 7.9569 |  |  |  |  | 0
 |  | Tuesday |  |  | 8.7594 |  |  |  |  | 0
 |  | Wednesday |  |  | 7.84 |  |  |  |  | 0
38 |  | Thursday |  |  | 10.0408 |  |  |  |  | 0 | 6
 |  | Friday |  |  | 10.2603 |  |  |  |  | 0
 |  | Saturday |  |  | 5.995
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 0 |  |  |  |  | 0
 |  | Tuesday |  |  | 10.1325 |  |  |  |  | 0
 |  | Wednesday |  |  | 9.9433 |  |  |  |  | 0
42 |  | Thursday |  |  | 9.0086 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 4.48 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 9.5839 |  |  |  |  | 0
 |  | Tuesday |  |  | 9.055 |  |  |  |  | 0
 |  | Wednesday |  |  | 7.9478 |  |  |  |  | 0
52 |  | Thursday |  |  | 8.1475 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 8.1425 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 8.1289 |  |  |  |  | 0
 |  | Tuesday |  |  | 9.2881 |  |  |  |  | 0
 |  | Wednesday |  |  | 8.0681 |  |  |  |  | 0
53 |  | Thursday |  |  | 10.0597 |  |  |  |  | 0 | 4.75
 |  | Friday |  |  | 8.7742 |  |  |  |  | 0
 |  | Saturday |  |  | 3.9497
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 8.02 |  |  |  |  | 0
 |  | Tuesday |  |  | 8.4919 |  |  |  |  | 0
 |  | Wednesday |  |  | 8.2739 |  |  |  |  | 0
54 |  | Thursday |  |  | 8.3583 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 0 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 8.0903 |  |  |  |  | 0
 |  | Tuesday |  |  | 9.1669 |  |  |  |  | 0
 |  | Wednesday |  |  | 9.5592 |  |  |  |  | 0
55 |  | Thursday |  |  | 8.5689 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 6.5086 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 8.2381 |  |  |  |  | 0
 |  | Tuesday |  |  | 0 |  |  |  |  | 0
 |  | Wednesday |  |  | 4.47 |  |  |  |  | 0
57 |  | Thursday |  |  | 8.8997 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 7.9642 |  |  |  |  | 0
 |  | Saturday |  |  | 4.2547
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 4.7664 |  |  |  |  | 0
 |  | Tuesday |  |  | 0 |  |  |  |  | 0
 |  | Wednesday |  |  | 8.1453 |  |  |  |  | 0
63 |  | Thursday |  |  | 8.8808 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 8.9781 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 8.9469 |  |  |  |  | 0
 |  | Tuesday |  |  | 8.8183 |  |  |  |  | 0
 |  | Wednesday |  |  | 8.3958 |  |  |  |  | 0
64 |  | Thursday |  |  | 7.94 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 5.3561 |  |  |  |  | 0
 |  | Saturday |  |  | 3.7219
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 7.9361 |  |  |  |  | 0
 |  | Tuesday |  |  | 7.9731 |  |  |  |  | 0
 |  | Wednesday |  |  | 4.3639 |  |  |  |  | 0
65 |  | Thursday |  |  | 7.7494 |  |  |  |  | 0 | 0
 |  | Friday |  |  | 1.9414 |  |  |  |  | 0
 |  | Saturday |  |  | 0
 |  | Sunday |  |  | 0
 |  | Monday |  |  | 0 |  |  |  |  | 0
 |  | Tuesday |  |  | 0 |  |  |  |  | 0
 |  | Wednesday |  |  | 0 |  |  |  |  | 0