Operations template
Employee Shift Schedule Template
Plan the week's shifts. Weekly hours per person and staff per day add up automatically.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Employee | Mon | Tue | Wed | Thu | Fri | Week |
| 2 | Anna | 8 | 8 | 0 | 8 | 8 | =SUM(B2:F2) |
| 3 | Ben | 0 | 8 | 8 | 8 | 8 | =SUM(B3:F3) |
| 4 | Cleo | 6 | 6 | 6 | 0 | 6 | =SUM(B4:F4) |
| 5 | Hours per day | =SUM(B2:B4) | =SUM(C2:C4) | =SUM(D2:D4) | =SUM(E2:E4) | =SUM(F2:F4) | =SUM(G2:G4) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
G2 =SUM(B2:F2)
Total hours for the week.
B5 =SUM(B2:B4)
Staffed hours that day.
Make it yours by asking
Try a request like this in Tabstra:
"Create a weekly shift schedule with employees, hours per day and total weekly hours, plus staff hours per day"