Spreadsheet: 693329d1598924173-time-formulas-project-work-hours-spreadsheet
Sheet: Sheet1

Total Weekly Project Work Hours
 |  |  |  |  |  |  |  |  |  | Regular Daily Hours: | 8:00:00
Employee | Employee Type | Project Name | Start 1 | End 1 | Total | Overtime | Start 2 | End 2 | Total 2 | Overtime 2 | Start 3 | End 3 | Total 3 | Overtime 3 | Total Hours | Total Overtime
[NAME] |  | Budweiser | 10:00:00 | 13:30:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | Employee | Employee Type
[NAME] |  | Budweiser | 10:40:00 | 15:30:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | [NAME] | Full Time
Kristal |  | Budweiser | 10:00:00 | 13:20:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | [NAME] | Full Time
Scott |  | Budweiser | 07:00:00 | 15:30:00 |  |  | 12:01:00 | 12:02:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | Alec | Full Time
Chanel |  | Budweiser | 09:06:00 | 13:54:00 |  |  | 12:01:00 | 12:02:00 |  |  | 12:01:00 | 12:02:00 |  |  |  |  |  | [NAME] | Full Time
[NAME] |  | Budweiser | 12:45:00 | 13:20:00 |  |  | 12:01:00 | 12:02:00 |  |  | 12:01:00 | 12:02:00 |  |  |  |  |  | Kristal | Full Time
[NAME] |  | Budweiser | 12:00:00 | 15:00:00 |  |  | 07:00:00 | 08:40:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | Antoine | Full Time
[NAME] |  | Cash Depot | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 09:22:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | Caden | Full Time
Kristal |  | Dominoes | 07:00:00 | 09:55:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | [NAME] | Full Time
Peyton |  | Dominoes | 07:00:00 | 14:45:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | [NAME] | Full Time
[NAME] |  | Dominoes | 07:00:00 | 10:00:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | Scott | Full Time
Scott |  | Dominoes | 07:00:00 | 12:55:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | [NAME] | Full Time
[NAME] |  | Dominos | 07:00:00 | 09:00:00 |  |  | 09:00:00 | 12:30:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | [NAME] | Full Time
Antoine |  | Dominos | 07:00:00 | 10:00:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | [NAME] | Full Time
Chanel |  | Dominos | 07:00:00 | 10:00:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | Chanel | Full Time
[NAME] |  | Dominos | 07:00:00 | 09:45:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | [NAME] | Full Time
Nneka |  | Dominos | 07:00:00 | 09:55:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | Aleksandr | Full Time
[NAME] |  | Dominos | 07:00:00 | 14:40:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | [NAME] | Full Time
[NAME] |  | Hennessy | 13:30:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  |  |  |  | [NAME] | Full Time
[NAME] |  | Hennessy | 07:00:00 | 15:30:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | Alexis | Full Time
Antoine |  | Hennessy | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  | 09:00:00 | 17:30:00 |  |  |  |  |  | Arshone | Full Time
Kristal |  | Hennessy | 13:20:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 13:30:00 |  |  |  |  |  | Nneka | Full Time
Peyton |  | Hennessy | 07:00:00 | 11:30:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00 |  |  |  |  |  | [NAME] | Full Time
[NAME] |  | Hennessy | 14:15:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  |  |  |  | Peyton | Full Time
Scott |  | Hennessy | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00
Chanel |  | Hennessy | 13:55:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 17:30:00
[NAME] |  | Hennessy | 13:25:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 17:15:00
[NAME] |  | Hennessy | 08:43:00 | 15:00:00 |  |  | 07:00:00 | 17:30:00 |  |  | 12:00:00 | 12:01:00
Alexis |  | Huron | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00
Nneka |  | Hurron | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00
[NAME] |  | Little Ceasears | 07:00:00 | 10:30:00 |  |  | 07:00:00 | 15:30:00 |  |  | 12:00:00 | 12:01:00
Kristal |  | Little Ceasears | 10:00:00 | 15:30:00 |  |  | 07:00:00 | 10:00:00 |  |  | 12:00:00 | 12:01:00
Peyton |  | Little Ceasears | 14:14:00 | 15:20:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00
[NAME] |  | Little [NAME] | 12:30:00 | 15:30:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00
[NAME] |  | Little [NAME] | 10:10:00 | 15:30:00 |  |  | 07:00:00 | 09:55:00 |  |  | 12:00:00 | 12:01:00
[NAME] |  | Little Ceasers | 10:00:00 | 15:15:00 |  |  | 07:00:00 | 10:00:00 |  |  | 12:01:00 | 12:02:00
Scott |  | Little Ceasers | 14:55:00 | 15:30:00 |  |  | 12:01:00 | 12:02:00 |  |  | 12:01:00 | 12:02:00
[NAME] |  | Little Ceasers | 14:40:00 | 15:00:00 |  |  | 07:00:00 | 10:20:00 |  |  | 12:00:00 | 12:01:00
Chanel |  | Sneeze Guard | 07:00:00 | 09:06:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00
[NAME] |  | Stearns & Fosters | 09:45:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  | 12:00:00 | 12:01:00
Peyton |  | Utah | 12:00:00 | 15:30:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00
[NAME] |  | Utah | 12:30:00 | 14:15:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00
[NAME] |  | utah | 10:05:00 | 13:45:00 |  |  | 12:00:00 | 12:01:00 |  |  | 12:00:00 | 12:01:00
Employee | Employee Type | Project Name | Start 1 | End 1 | Total | Overtime | Start 2 | End 2 | Total 2 | Overtime 2 | Start 3 | End 3 | Total 3 | Overtime 3 | Total Hours | Total Overtime
[NAME] | Temp | Hennessy | 07:00:00 | 15:30:00 |  |  | 07:00:00 | 15:30:00 |  |  | 12:00:00 | 12:01:00
Christina | Temp | Dominoes | 07:40:00 | 12:00:00 |  |  | 12:01:00 | 12:02:00 |  |  | 12:01:00 | 12:02:00
Christina | Temp | Little Ceasers | 12:00:00 | 14:00:00 |  |  | 12:01:00 | 12:02:00 |  |  | 12:01:00 | 12:02:00
Christina | Temp | Budweiser | 09:16:00 | 14:05:00 |  |  | 12:01:00 | 12:02:00 |  |  | 12:01:00 | 12:02:00
Christina | Temp | Hennessy | 07:40:00
Employee Type | Project Name | Total Hours | Total Overtime Hours
Full Time | Hennessy | #N/A | #N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A