Features

Who it is for

More

Excel and PDF

Timesheet per site, with the 7-day deadline under section 17 MiLoG

One month per person, one row per job. The Excel file adds up the hours per site, checks every day against the Working Hours Act and flags entries recorded later than seven days.

Download XLSXDownload PDF
  • No sign-up
  • No newsletter
  • Free to use
Preview: Timesheet per site, with the 7-day deadline under section 17 MiLoG

What is in the template?

Ready to use, with formulas, sample data and a legend.

  • A "Recorded on" column flagged once the seven days have passed
  • Hours per site in the month on a sheet of its own
  • A daily check across all entries: ten hours, breaks, rest
  • Jobs past midnight with the date of the start
  • A PDF with signature fields for employee and employer

When does the template fit?

Ideal as an interim solution or for small teams, with clear limits.

  • Construction firms and crews on changing sites
  • Proof towards customs during inspections
  • A paper timesheet as a PDF for the site
When Excel reaches its limits

Tuesday's sheet is still in the van on Friday of the following week.

With MetronHR the crew clocks in via the app on site, the record exists on the same day and stays available for two years. The hours per site go into the monthly summary and to the accountant as a payroll file without retyping.

How MetronHR solves it
In comparison
Excel templateMetronHR
UpkeepManual upkeepAutomatic calculations
ApprovalsNo workflowsApproval workflow
RemindersNo remindersReminders
TeamCopy again for every employeeOne central source for the whole team
More templates

Also goes with this

Hours per job for payroll and job costingGo to the templateAttendance and job time kept apart, with labour units and efficiencyGo to the templateDrive, job and emergency call per customer, with rest until the next morningGo to the templateWorking time and client time in one list, with the billable shareGo to the template

Frequently asked questions

Answers on usage and legal aspects.

Question not answered here? Every step is explained in the help centre.

Send us a message
By when must working hours in construction be recorded?

By the end of the seventh calendar day after the working day (section 17(1) MiLoG). Construction is listed in section 2a(1) no. 1 SchwarzArbG, so the duty applies to all employees, not only mini-jobbers. Records are kept for two years.

Is the drive to the site working time?

From the yard where material or the crew is collected, yes. The drive from home to a fixed site is usually the commute.

What has to be carried on site?

An identity card, passport or substitute document, shown to customs on request (section 2a SchwarzArbG). The employer points this out in writing.

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.

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