Spreadsheet: 859128d1707584131-creating-a-schedule-using-the-if-formula-weekly_employee_schedule_template
Sheet: Cashiers Weekly

 |  |  |  |  |  |  | This Week's Schedule |  |  |  |  |  |  |  | 2024-02-04 00:00:00
 |  | Sunday |  |  |  |  | Monday |  |  |  |  | Tuesday |  |  |  |  | Wednesday |  |  |  |  | Thursday |  |  | Friday |  |  | Saturday |  |  | Total Hours
 | Employee | Shift Start | 15 | 30 | Shift End | Hours | Shift Start | 15 | 30 | Shift End | Hours | Shift Start | 15 | 30 | Shift End | Hours | Shift Start | 15 | 30 | Shift End | Hours | Shift Start | Shift End | Hours | Shift Start | Shift End | Hours | Shift Start | Shift End | Hours | Per Employee
Cashiers
1 | 1.Chiara | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | off |  |  | off | 0 | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
2 | [NAME] b | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
3 | Jessica | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
4 | [NAME] | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
5 | Natalia | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
6 | Jessica | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
7 | [NAME] | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
8 | Jessica | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
9 | Chaz | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
10 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
11 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
12 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
13 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
14 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
15 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
16 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
17 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
18 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
19 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
20 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
21 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
22 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
23 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
24 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
25 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
26 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
27 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
28 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
29 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
30 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
31 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
32 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
33 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
34 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
35 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
36 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
37 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
38 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
39 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
40 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
41 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
42 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
43 |  | 06:00:00 |  | 00:30:00 | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 |  |  | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00 |  | 06:00:00 | 14:00:00
Total Employee Hours Per Day: