Timesheet template 2026
An Excel timesheet for all 12 months: Latvian public holidays 2026, shortened pre-holiday days and transferred working days already marked. Hours worked, norm and hours above norm are calculated for you.
What is inside
One file for the whole year. The formulas are in place — just enter the hours.
12 monthly sheets
Each month has its own sheet with dates and weekdays, up to 20 workers per sheet. Rows can be copied.
Holidays marked
Weekends and holidays are grey, pre-holiday days (7 h) yellow, transferred working Saturdays green.
Totals calculate themselves
Hours worked, individual norm, hours above norm, hours on public holidays and days worked for each worker.
Codes A, B, BA, K, N
Leave, sick leave, unpaid leave, business trip and absence — the sheet counts them and reduces the norm.
Calendar sheet
Working days and hours by month and for the year, with holidays and pre-holiday days — taken from the monthly sheets.
Ready to print
A4 landscape, header on every page, space for a signature. Input check: 0–24 h or a code.
Working-time calendar 2026 (Latvia)
Five-day week, 8 hours a day (40 hours a week). On a pre-holiday day working time is one hour shorter.
| Month | Working days | Hours | Public holidays | Pre-holiday days |
|---|---|---|---|---|
| January | 21 | 168 | 1 — New Year | — |
| February | 20 | 160 | — | — |
| March | 22 | 176 | — | — |
| April | 20 | 158 | 3 — Good Friday; 5, 6 — Easter | 2, 30 |
| May | 19 | 152 | 1 — Labour Day; 4 — Restoration of Independence; 24 — Whit Sunday | — |
| June | 20 | 159 | 23 — Līgo; 24 — Jāņi | 27 (Sat) |
| July | 23 | 184 | — | — |
| August | 21 | 168 | — | — |
| September | 22 | 176 | — | — |
| October | 22 | 176 | — | — |
| November | 20 | 159 | 18 — Proclamation Day | 17 |
| December | 20 | 158 | 24–26 — Christmas; 31 — New Year's Eve | 23, 30 |
| Year | 250 | 1994 |
Transferred days under Cabinet Order No. 330 of 12.06.2025: Friday 2 January moved to Saturday 17 January; Monday 22 June to Saturday 27 June (shortened, 7 h). Mandatory for state institutions, a recommendation for companies; the annual number of working days and hours does not change. Based on Labour Law Sections 131 and 135.
How to fill in the timesheet
Set up the month
Enter the company, project or department and the workers' names. Copy the sheet for each project.
Fill it in daily
Against each day — hours worked (8; 7.5) or a code: A, B, BA, K, N. Best on the same day, not from memory at month end.
Hand it to payroll
At month end the totals are ready: hours, norm, above norm and on holidays. Sign it and pass it on for payroll.
What to know about working time in 2026
- Normal working time is 8 hours a day and 40 hours a week (Labour Law Section 131).
- On a pre-holiday day working time is one hour shorter (Section 135). There are 6 such days in 2026.
- Overtime and work on public holidays are paid with a supplement of at least 100 % (Section 68).
- Summarised working time (Section 140) is common in construction: the norm is counted over the reference period, not per day. The «Above norm» column shows exactly that difference.
- Records must be kept: the employer must record each worker's hours, including overtime and work on public holidays (Section 136).
The template is not legal advice. If your company has a collective agreement or a different reference period, follow it.
Why an Excel timesheet fails on site
A spreadsheet works for an office and a small team. Once crews are on several sites, Excel becomes guesswork.
Filled in from memory
Hours are entered on Friday or at month end. Nobody remembers exactly who arrived when.
Several sites
One file, several foremen, different versions. Hours per site have to be pieced together.
Pay disputes
If the sheet does not match the worker's notes, there is nothing to prove who is right.
Frequently asked questions
Is the timesheet free?
How many working days and hours are there in 2026?
How do I mark leave and sick leave?
How does the sheet count overtime?
Can the timesheet fill itself in?
Want the timesheet to fill itself in?
GPS shift on site, hours in the timesheet and payroll from them — MeistarPro. 14 days free.
Try 14 days free