All templates
Business
Employee Rota
Plan shifts for the week and total the hours automatically.
Rota3 rows
| # | AName | BMon | CTue | DWed | EThu | FFri | GHours |
|---|---|---|---|---|---|---|---|
| 1 | Ellie | 9-5 | 9-5 | Off | 9-5 | 9-1 | 28 |
| 2 | Dan | Off | 12-8 | 12-8 | 12-8 | 12-8 | 32 |
| 3 | Rae | 9-1 | Off | 9-5 | 9-5 | Off | 20 |
What it tracks
- Shifts per person
- Weekly hours
- Cover gaps
Included sheets
RotaStaffHours
Key calculations
- Weekly hours
- =SUM(ShiftHours)
- Cover per day
- =COUNTIF(B:B,"<>Off")