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.
- 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
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.
In comparison
Excel template
Manual upkeep • no workflows • no reminders • copy anew for every employee
MetronHR
Automatic calculations • approval workflow • reminders • one central source for the whole team
Frequently asked questions
Answers on usage and legal aspects.
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.
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).
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.
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.
Question not answered here? Every step is explained in the help centre.
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.
Ready in 5 minutes, no credit card