Times per hirer under section 17c AUeG, with the 7-day deadline
One row per assignment with hirer, place of work and recording date. The Excel file sums up per hirer, flags late entries and checks the day across all hirers together.
- No sign-up
- No newsletter
- Free to use
What is in the template?
Ready to use, with formulas, sample data and a legend.
- Hirer, place of work and task per row
- A "Recorded on" column flagged after seven days
- Hours per hirer on a sheet of their own
- A daily check across all hirers: ten hours, breaks, rest
- A note on the maximum assignment period of 18 months
When does the template fit?
Ideal as an interim solution or for small teams, with clear limits.
- Staffing agencies with assignments at several hirers
- Hirers keeping the records themselves
- An hours record as a PDF to countersign
Two hirers, two sheets, one working day: neither of them sees the twelve hours.
With MetronHR temporary workers clock in via the app at the place of work, and the record exists on the same day. The hours are collected per client, and at month end the payroll file goes to the accountant.
| 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 |
Also goes with this
Frequently asked questions
Answers on usage and legal aspects.
Question not answered here? Every step is explained in the help centre.
Send us a messageWho records working time in temporary work?
The hirer, as long as a minimum pay rate under section 3a AUeG applies: start, end and duration by the end of the seventh calendar day, kept for two years (section 17c(1) AUeG). The seventh minimum pay ordinance has applied since 1 July 2026, until 30 September 2027. The agency keeps the documents available in Germany and in German (section 17c(2)).
What applies if someone works for two hirers on one day?
The daily limit and the rest period apply to the total. Eight hours in the warehouse and four hours of trade fair set-up in the evening make twelve hours, above the limit of ten (section 3 ArbZG). The template flags exactly this case in the example.
How long may an assignment with the same hirer last?
At most 18 consecutive months. Earlier assignments count if the gap between them is at most three months (section 1(1b) AUeG). Collective agreements of the hirer's industry can deviate.
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