Monthly duty roster with shift codes
One sheet for the whole month: enter a code per day and the hours total per person calculates itself, with the codes freely changeable.
- No sign-up
- No newsletter
- Free to use
What is in the template?
Ready to use, with formulas, sample data and a legend.
- Up to 20 people times 31 days on one sheet
- Freely changeable shift codes on a sheet of their own
- An hours total per person and for the whole team automatically
- The first column and the header row frozen, for long scrolling
- Notes on rest periods, maximum working time and Sunday work on the sheet
When does the template fit?
Ideal as an interim solution or for small teams, with clear limits.
- Hospitality, retail, care and security services
- Businesses with early, late and night duties
- A notice board display as a PDF
The plan does not notice when the rest period is breached.
A late shift until 10 pm and an early shift from 6 am the next morning: eight hours of rest instead of the eleven required by section 5 ArbZG. In Excel that only comes to light when somebody does the arithmetic. MetronHR checks while you plan, reports the conflict immediately and sets the plan against the time recorded.
| Excel template | MetronHR | |
|---|---|---|
| Upkeep | Manual upkeep | Automatic calculations |
| Approvals | No workflows | Approval workflow |
| Reminders | No reminders | Reminders |
| Team | Copy again for every employee | One central source for the whole team |
Frequently asked questions
Answers on usage and legal aspects.
Question not answered here? Every step is explained in the help centre.
Send us a messageHow far in advance must a duty roster be set?
The Working Time Act sets no deadline. For work on demand section 12 of the Part-Time and Fixed-Term Employment Act applies: the timing of the work must be communicated at least four days in advance, otherwise the employee does not have to work. Collective and works agreements often set longer notice periods.
How much rest must there be between two shifts?
At least eleven uninterrupted hours (section 5 (1) ArbZG). In hospitals, care facilities, restaurants, transport operations, broadcasting and agriculture it may be shortened to ten hours if every reduction is compensated within one calendar month or four weeks by an extension to at least twelve hours (section 5 (2) ArbZG).
Does the works council have to approve the duty roster?
If there is a works council: yes. The start and end of daily working time including breaks and the distribution of working time across the days of the week are subject to co-determination under section 87 (1) no. 2 BetrVG, and a temporary extension or reduction of working time under no. 3.
Does the duty roster replace recording working time?
No. The plan says who should work; the record says who actually worked when. The duty from the Federal Labour Court decision of 13 September 2022 (1 ABR 22/21) relates to actual working time.
Templates are a start. MetronHR is the answer.
When Excel reaches its limits in a team, MetronHR takes over the process. Try it free for 14 days.
- No credit card required
- Ready quickly
- Cancel monthly
- Full access to every feature
Ready in 5 minutes, no credit card