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.
- No sign-up
- No newsletter
- Free to use
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.
| 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 long does the break have to be?
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.
Does the break count as working time?
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.
How many hours a day are allowed?
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.
Why does the template warn even though I entered a shorter break?
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.
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