Which public holidays are in it?

The ones of the country of this page's language, for four years. You can add or delete days on the Holidays sheet — the timesheet uses that list.

How is overtime counted?

Counted hours (worked plus leave, sick days and other paid absences) minus the expected hours of the day. Work on a weekend or public holiday is all overtime.

Can my employer use it?

It is a personal record. Rules for working time and overtime are set by your contract and labour law.

Excel templates

Timesheet and leave tracker in Excel

Write your arrival and departure; the workbook counts hours, overtime and leave, marks weekends and public holidays and sums it up by month.

Download free (.xlsx)Free · no sign-up

Works in Excel, Google Sheets, Apple Numbers and LibreOffice.

Timesheet-Planmero.xlsx

	A	B	C	D	E	F
1	Date	Day type	Arrival	Departure	Absence	Overtime (h)
2	1/4/2027	Working day	7:30	16:15		+0.25
3	1/5/2027	Working day	7:45	16:00		–
4	1/6/2027	Public holiday				–
5	1/7/2027	Working day			Leave	–
6	1/8/2027	Working day	7:30	17:30		+1.50
7	1/9/2027	Weekend				–

How to useSettingsTimesheetSummaryHolidays

What's inside

All 365 days of the year with weekends and public holidays marked
Arrival, departure and break → hours worked and overtime
Leave, half-day leave, sick days, doctor and time off from a drop-down
Monthly summary: working days, expected hours, hours worked, overtime
Leave balance: entitlement, carried over, taken, left

How to use it

1On the Settings sheet enter your name, the year, your hours per day and your leave entitlement in days.
2On the Timesheet sheet write the arrival and departure time (e.g. 7:30 and 16:00) and the break in minutes.
3On days off choose the reason from the drop-down: leave, half-day leave, sick day, doctor, time off, unpaid leave or business trip.
4The Summary sheet shows each month and your remaining leave.

Download free (.xlsx)

Questions

Which public holidays are in it?: The ones of the country of this page's language, for four years. You can add or delete days on the Holidays sheet — the timesheet uses that list.
How is overtime counted?: Counted hours (worked plus leave, sick days and other paid absences) minus the expected hours of the day. Work on a weekend or public holiday is all overtime.
Can my employer use it?: It is a personal record. Rules for working time and overtime are set by your contract and labour law.

Tips

Times are entered as hours:minutes, e.g. 8:15. A night shift past midnight is counted correctly.
Grey rows are weekends, orange ones public holidays.
Need another country's holidays? Change the list on the Holidays sheet.