Calculate working time with a break check
Enter the start and end, and the template deducts the required break and warns when the limits of the Working Time Act are exceeded.
- Net working time from start, end and break
- A suggested break under section 4 ArbZG: 30 minutes over six hours, 45 minutes over nine
- A warning at more than eight and at more than ten hours
- Calculates with the greater of the entered and the statutory break
What is in the template?
Ready to use, with formulas, sample data and a legend.
- Net working time from start, end and break
- A suggested break under section 4 ArbZG: 30 minutes over six hours, 45 minutes over nine
- A warning at more than eight and at more than ten hours
- Calculates with the greater of the entered and the statutory break
- A monthly total at the end of the sheet
When does the template fit?
Ideal as an interim solution or for small teams, with clear limits.
- Checking individual days before they go into payroll
- Checking whether a planned shift stays within the limits
- Training managers on the break rules
Checking the arithmetic is good. Not having to check it is better.
The template calculates a day once it is over. MetronHR calculates as you clock: the break is deducted automatically, a breach of maximum working time or rest periods appears as a warning before the month is closed, and the report is ready at the end of the month.
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.
At more than six hours of working time at least 30 minutes, at more than nine hours at least 45 minutes (section 4 ArbZG). The break may be split into segments of at least 15 minutes each. Nobody may be employed for more than six hours in a row without a rest break.
No. Rest breaks are interruptions of working time and are in principle unpaid. It is different only where a collective agreement, works agreement or employment contract provides otherwise, or where the person has to remain available during the break; in that case it is not a rest break.
Eight hours per working day. Ten hours are permitted if an average of eight hours per working day is not exceeded within six calendar months or 24 weeks (section 3 ArbZG). Working days within the meaning of the act are Monday to Saturday, which gives 48 hours a week on average.
Because the statutory break applies even if it was not taken. The template calculates with the greater of the entered and the required break and flags this in the notes column. That way you see immediately where the break rules were not observed.
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