Weekly or monthly timesheet template that adds up the hours
Enter start, end and break for each day. The timesheet works out every day and the total for the week or the month, in hours and minutes and in decimal hours, prints on a single page and downloads as a CSV file for Excel or Google Sheets.
Break deducted, shifts past midnight recognised, total as h:mm and as decimal hours.
Nothing is sent or saved: the sheet exists only in this browser tab.
Print it on one A4 page with signature lines, or download it as a CSV file.
Your timesheet
Pick any day: the sheet starts on that week's Monday or on the 1st of that month.
h:mm or decimal hours. The total then shows overtime or hours short.
Timesheet
Employee
Business
Period
Timesheet
Type times as 7:30 or 0730 and the break in minutes; the hours appear as soon as a row has a start and an end.
Day
Start
End
Break (min)
Hours
Note
Monday
min
Tuesday
min
Wednesday
min
Thursday
min
Friday
min
Saturday
min
Sunday
min
min
Total—
decimal hours
Days worked
—
Average per day
—
Against contract
—
Date, signature of employee
Date, signature of employer
Nothing you type leaves this tab, and reloading the page empties the sheet — keep the printout or the CSV file.
How the sheet counts
A day from 07:30 to 16:15 with a 45-minute break is 8 hours 45 minutes at work less the break: 8:00, or 8.00 decimal hours. The sheet does that for every row as soon as a start and an end are filled in.
An end time earlier than the start means the shift ended the next morning: 22:00 to 06:00 with a 30-minute break is 7:30. The row is counted on the day the shift began.
Decimal hours are what payroll and invoices multiply by a rate: 45 minutes is 0.75 hours, because 45 ÷ 60 = 0.75. The sheet adds up minutes and converts the total once, so the decimal total never drifts by a hundredth from the hours and minutes beside it.
Enter the contracted hours for the period and the total also shows the difference: 41:30 worked against 40:00 is 1:30 overtime.
Recording working time: what the rules say
Whether and how working time has to be recorded depends on the country. These are the rules for the EU and for Great Britain, with a German example.
EU: a system that measures every day
On 14 May 2019 the Court of Justice of the EU ruled (C-55/18, CCOO) that Member States must require employers to set up an objective, reliable and accessible system enabling the duration of time worked each day by each worker to be measured. The specific arrangements for such a system, in particular the form it takes, are for each Member State to determine.
Germany, as an example: paper can be enough
Germany's Federal Labour Court held on 13 September 2022 (1 ABR 22/21) that employers must record the start and end of each employee's daily working time. Depending on the work and the business, records on paper can be sufficient, and the recording itself may be left to the employees.
Great Britain: records that show the limits are kept
Regulation 9 of the Working Time Regulations 1998 requires records adequate to show that the working-time limits are complied with — among them the average of 48 hours a week in regulation 4(1), unless the worker has agreed in writing to work more — kept for two years. The format is up to the employer, and daily hours need not be recorded for each worker if compliance can be shown another way.
Breaks after six hours
Directive 2003/88/EC gives every worker in the EU a rest break once the working day is longer than six hours (Article 4); its length is set by collective agreement or national law. In Great Britain an adult worker gets at least 20 uninterrupted minutes (regulation 12), unless a collective or workforce agreement provides otherwise.
This page stores nothing. If your timesheets have to be kept, keep the printout or the CSV file yourself.
Checked on 26 September 2026 at the sources below. Northern Ireland and other countries outside the EU have their own rules, and collective agreements or contracts can add to them. General information, not legal advice.
That depends on the country. The EU requires a system that measures each worker's daily working time but leaves its form to each Member State; in Germany, for example, the Federal Labour Court has held that paper records can be sufficient. In Great Britain the employer may keep the records in any format it reasonably thinks fit.
Divide the minutes by 60 and add them to the hours: 7 hours 45 minutes is 7 + 45 ÷ 60 = 7.75 hours. The sheet shows every row and the total both ways; for single values there is the minutes-to-decimal converter linked below.
Enter the end time as it was on the clock. An end earlier than the start is read as the next morning, so 22:00 to 06:00 counts eight hours before the break, on the day the shift began.
In Great Britain, working-time records are kept for two years (regulation 9 of the Working Time Regulations 1998). In Germany, the two provisions that expressly require records name at least two years as well. Other countries set their own periods — and since this page stores nothing, keeping them is up to you.
No. The sheet is calculated in your browser and nothing is sent to a server or kept in the browser. Reloading or closing the page empties it, which is why printing and the CSV download are the two ways to keep it.
Yes: enter the contracted hours for the week or month above the sheet, as h:mm or decimal hours. The total then shows how far the recorded hours are above or below them.
Necessary cookies keep the site secure. Analytics and external content only run after your choice.
·
Cookie settings
You can decide whether we may enable optional analytics features and external content. You can revoke or adjust your choice at any time via the Cookie settings link.
Necessary technologies
Required for sessions, security, sign-in, and the website's core functions.