Spreadsheet: 873386d1719880568-sumifs-issues-or-wrong-formula-book1
Sheet: Harri Report

Name | Position Name | Pay Rate | Day Name | Date | Clock In | Clock Out | Total Hours | Regular Hours | Unpaid Breaks Hours | Shift Value | Total Cost
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 13:56:00 | 23:29:00 | 9.55 | 9.22 | 0.33 | 1 | 149.31
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 13:57:00 | 23:44:00 | 9.78 | 9.42 | 0.37 | 1 | 152.55
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 15:27:00 | 00:11:00 | 8.73 | 8.4 | 0.33 | 1 | 136.08
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 15:26:00 | 00:13:00 | 8.78 | 8.45 | 0.33 | 1 | 136.89
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 16:55:00 | 23:33:00 | 6.63 | 6.63 |  | 1 | 107.46
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 14:01:00 | 23:44:00 | 9.72 | 9.38 | 0.33 | 1 | 152.01
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 13:57:00 | 23:45:00 | 9.8 | 9.47 | 0.33 | 1 | 153.36
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 15:26:00 | 00:08:00 | 8.7 | 8.37 | 0.33 | 1 | 135.54
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 15:26:00 | 00:14:00 | 8.8 | 8.47 | 0.33 | 1 | 137.16
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 13:55:00 | 23:14:00 | 9.32 | 8.98 | 0.33 | 1 | 145.53
[NAME] | Sommelier | 12.5 | Wednesday | 2024-06-26 00:00:00 | 15:25:00 | 23:26:00 | 8.02 | 7.73 | 0.28 | 1 | 96.67
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 13:59:00 | 23:39:00 | 9.67 | 9.33 | 0.33 | 1 | 151.2
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 16:25:00 | 23:45:00 | 7.33 | 7.33 |  | 1 | 118.8
Chelsea Lopez | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 15:27:00 | 00:13:00 | 8.77 | 8.43 | 0.33 | 1 | 136.62
[NAME] | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 13:55:00 | 23:24:00 | 9.48 | 9.15 | 0.33 | 1 | 148.23
Homer Scott | Training | 16.2 | Wednesday | 2024-06-26 00:00:00 | 16:55:00 | 23:35:00 | 6.67 | 6.67 |  | 1 | 108
Name | Position Name | Pay Rate | Day Name | Date | Clock In | Clock Out | Total Hours | Regular Hours | Unpaid Breaks Hours | Shift Value | Total Cost
[NAME] | Food [NAME] | 11.02 | Thursday | 2024-06-27 00:00:00 | 14:56:00 | 16:00:00 | 1.07 | 1.07 |  | 1 | 11.75
[NAME] | Server | 11.02 | Thursday | 2024-06-27 00:00:00 | 15:33:00 | 23:14:00 | 7.68 | 7.35 | 0.33 | 1 | 81
[NAME] | Food [NAME] | 11.02 | Thursday | 2024-06-27 00:00:00 | 15:55:00 | 22:44:00 | 6.82 | 6.82 |  | 1 | 75.12
[NAME] | Sommelier | 12.5 | Thursday | 2024-06-27 00:00:00 | 15:23:00 | 23:00:00 | 7.62 | 7.28 | 0.33 | 1 | 91.04
[NAME] | Barback | 11.02 | Thursday | 2024-06-27 00:00:00 | 14:59:00 | 23:00:00 | 8.02 | 7.68 | 0.33 | 1 | 84.67
[NAME] | Server | 11.02 | Thursday | 2024-06-27 00:00:00 | 15:57:00 | 23:09:00 | 7.2 | 7.2 |  | 1 | 79.34
[NAME] | Food [NAME] | 11.02 | Thursday | 2024-06-27 00:00:00 | 15:56:00 | 22:39:00 | 6.72 | 6.72 |  | 1 | 74.02
[NAME] | Server | 11.02 | Thursday | 2024-06-27 00:00:00 | 15:44:00 | 23:11:00 | 7.45 | 7.45 |  | 1 | 82.1
[NAME] | Server | 11.02 | Thursday | 2024-06-27 00:00:00 | 15:56:00 | 23:08:00 | 7.2 | 7.2 |  | 1 | 79.34
[NAME] | Bartender | 11.02 | Thursday | 2024-06-27 00:00:00 | 14:58:00 | 00:07:00 | 9.15 | 8.85 | 0.3 | 1 | 97.53
[NAME] | Server | 11.02 | Thursday | 2024-06-27 00:00:00 | 15:27:00 | 23:11:00 | 7.73 | 7.4 | 0.33 | 1 | 81.55
[NAME] | Lead Bartender | 15 | Thursday | 2024-06-27 00:00:00 | 15:06:00 | 00:07:00 | 9.02 | 8.77 | 0.25 | 1 | 131.5
Chelsea Lopez | Server | 11.02 | Thursday | 2024-06-27 00:00:00 | 15:55:00 | 23:08:00 | 7.22 | 7.22 |  | 1 | 79.53
[NAME] | Server | 11.02 | Thursday | 2024-06-27 00:00:00 | 16:02:00 | 22:54:00 | 6.87 | 6.87 |  | 1 | 75.67
Homer Scott | Food [NAME] | 11.02 | Thursday | 2024-06-27 00:00:00 | 16:35:00 | 22:49:00 | 6.23 | 6.23 |  | 1 | 68.69
[NAME] | Barback | 11.02 | Thursday | 2024-06-27 00:00:00 | 14:56:00 | 00:13:00 | 9.28 | 8.95 | 0.33 | 1 | 98.63
[NAME] | Server | 11.02 | Thursday | 2024-06-27 00:00:00 | 15:57:00 | 23:09:00 | 7.2 | 6.87 | 0.33 | 1 | 75.67
Name | Position Name | Pay Rate | Day Name | Date | Clock In | Clock Out | Total Hours | Regular Hours | Overtime | Unpaid Breaks Hours | Shift Value | Total Cost
[NAME] | Server | 11.02 | Friday | 2024-06-28 00:00:00 | 16:30:00 | 23:28:00 | 6.97 | 6.97 |  |  | 1 | 76.77
[NAME] | Food [NAME] | 11.02 | Friday | 2024-06-28 00:00:00 | 16:25:00 | 23:11:00 | 6.77 | 6.77 |  |  | 1 | 74.57
[NAME] | Sommelier | 12.5 | Friday | 2024-06-28 00:00:00 | 15:57:00 | 23:20:00 | 7.38 | 6.93 |  | 0.45 | 1 | 86.67
[NAME] | Bartender | 11.02 | Friday | 2024-06-28 00:00:00 | 14:58:00 | 00:19:00 | 9.35 | 8.85 |  | 0.5 | 1 | 97.53
[NAME] | Server | 11.02 | Friday | 2024-06-28 00:00:00 | 14:58:00 | 23:43:00 | 8.75 | 8.42 | 5.48 | 0.33 | 1 | 92.75
[NAME] | Food [NAME] | 11.02 | Friday | 2024-06-28 00:00:00 | 14:56:00 | 23:25:00 | 8.48 | 8.15 |  | 0.33 | 1 | 89.81
[NAME] | Server | 11.02 | Friday | 2024-06-28 00:00:00 | 16:28:00 | 23:42:00 | 7.23 | 6.9 |  | 0.33 | 1 | 76.04
[NAME] | Training | 11.02 | Friday | 2024-06-28 00:00:00 | 15:00:00 | 22:44:00 | 7.73 | 7.4 |  | 0.33 | 1 | 81.55
[NAME] | Bartender | 11.02 | Friday | 2024-06-28 00:00:00 | 14:58:00 | 00:20:00 | 9.37 | 8.95 |  | 0.42 | 1 | 98.63
[NAME] | Server | 11.02 | Friday | 2024-06-28 00:00:00 | 14:59:00 | 23:28:00 | 8.48 | 8.15 |  | 0.33 | 1 | 89.81
[NAME] | Food [NAME] | 11.02 | Friday | 2024-06-28 00:00:00 | 16:30:00 | 23:26:00 | 6.93 | 6.93 |  |  | 1 | 76.41
[NAME] | Lead Bartender | 15 | Friday | 2024-06-28 00:00:00 | 14:57:00 | 00:21:00 | 9.4 | 2.22 | 6.88 | 0.3 | 1 | 190.88
Chelsea Lopez | Server | 11.02 | Friday | 2024-06-28 00:00:00 | 16:25:00 | 23:27:00 | 7.03 | 7.03 |  |  | 1 | 77.51
[NAME] | Server | 11.02 | Friday | 2024-06-28 00:00:00 | 15:01:00 | 23:43:00 | 8.7 | 8.37 |  | 0.33 | 1 | 92.2
Homer Scott | Sommelier | 12.5 | Friday | 2024-06-28 00:00:00 | 15:25:00 | 21:20:00 | 5.92 | 5.57 |  | 0.35 | 1 | 69.58
[NAME] | Food [NAME] | 11.02 | Friday | 2024-06-28 00:00:00 | 16:35:00 | 23:26:00 | 6.85 | 6.85 | 3.82 |  | 1 | 75.49
[NAME] | Barback | 11.02 | Friday | 2024-06-28 00:00:00 | 15:29:00 | 00:15:00 | 8.77 | 8.5 |  | 0.27 | 1 | 93.67
[NAME] | Server | 11.02 | Friday | 2024-06-28 00:00:00 | 16:25:00 | 23:27:00 | 7.03 | 7.03 |  |  | 1 | 77.51
Sophie Jones | Server | 11.02 | Friday | 2024-06-28 00:00:00 | 16:25:00 | 23:30:00 | 7.08 | 7.08 |  |  | 1 | 78.06
[NAME] | Barback | 11.02 | Friday | 2024-06-28 00:00:00 | 15:05:00 | 00:21:00 | 9.27 | 8.93 |  | 0.33 | 1 | 98.45