Free Excel Timesheet Template – and an Honest Look at When Excel Stops Working
Download a ready-made monthly timesheet for tracking employee attendance in Excel: night shifts, break checks and a summary for the whole team. Then see what Excel really costs you in admin time, and when an app is worth it.
✓ No sign-up, no email · ✓ No macros · ✓ Excel 2010 or newer
Updated 26 October 2026
How do you track attendance in Excel? Give each employee their own sheet with one row per day of the month. Enter clock-in, clock-out and break; a formula turns them into hours worked and compares them with scheduled hours. Weekends and public holidays are marked automatically. But Excel only records what someone types – it cannot confirm who actually showed up.
What the Excel timesheet template looks like
This is one employee's sheet. You fill in the yellow cells; formulas do the rest. The snippet comes from the "Example" sheet in the file, filled in for September 2026.
Date
Clock in
Clock out
Break (min)
Absence
Worked (h)
Over schedule (h)
Check
8
Sep 1 Tue
7:00
15:30
30
8.00
-
9
Sep 2 Wed
7:00
15:30
30
8.00
-
10
Sep 3 Thu
7:00
15:30
30
8.00
-
11
Sep 4 Fri
7:05
18:10
30
10.58
2.58
12
Sep 5 Sat
-
-
13
Sep 6 Sun
-
-
14
Sep 7 Mon
7:00
15:30
30
8.00
-
15
Sep 8 Tue
6:55
-
-
Missing clock-out
16
Sep 9 Wed
7:00
15:30
30
8.00
-
17
Sep 10 Thu
7:00
15:00
10
7.83
-
Break too short
From the template: the weekend is grey, Sep 4 has 2.58 h over schedule, Sep 8 is missing a clock-out and Sep 10 has a break that is too short.
What the template does
Dates and weekdays fill themselves
Change the year and month on the Settings sheet and every sheet recalculates, including month length and leap years.
Your public holidays
Add your country's holidays once on the Settings sheet. Those days get zero scheduled hours on every employee sheet.
Night shifts across midnight
A 22:00–06:00 shift counts as 8 hours, not −16. This is where home-made timesheets break most often.
An error check on every row
The Check column flags a missing clock-in or clock-out, a break shorter than your minimum on shifts over 6 hours, a shift over 12 hours and an empty workday.
Absence codes from a drop-down
Vacation, sick leave, TOIL, business trip, remote work and unpaid leave are in a list. Rename them or add your own; the summary counts them.
One summary for the whole team
The Summary sheet totals hours worked, scheduled hours, overtime, absences and warnings for every employee at once.
Download the free template
One file, no macros and no email address required. It includes instructions, a settings sheet, three blank employee sheets, a team summary and a filled-in example.
Use and adapt the template freely inside your company. Sheets are not locked, so you can read and change every formula. For the rota, use our Excel shift schedule template.
Set it up in 15 minutes
1
Set the month and contract hours
On the Settings sheet, enter your company, year, month, hours per day (for example 8 or 7.5) and the minimum break. Add your public holidays.
2
Create a sheet per person
Type a name on "Employee 1". For more people, copy the sheet (right-click the tab › Move or Copy) and add its name to the Summary sheet.
3
Fill it in every day
Type clock-in and clock-out as 7:30, the break in minutes and an absence code when needed. Don't leave it to the end of the month.
4
Clear the warnings before payroll
Go through the Check column and the Summary sheet. Fix missing clock-outs first, then send the file to whoever runs payroll.
How much time an Excel timesheet really costs
Excel itself is free. You pay in time – and it is more than you would expect. Wherever there are shifts, part-timers and paper sheets, month-end turns into a day of chasing and counting. The breakdown below is for a small restaurant with 10 staff.
“Adding up the hours for one small restaurant took a full day of work every month.”
That is how our hospitality customers describe life before Fresh QR. Today their data is collected with every scan, and the monthly timesheet is ready when the month ends.
Collect sheets, messages and photos from cooks, servers and part-timers5–10 min / person
Chase missing clock-ins and clock-outs, confirm who actually worked the shift10–15 min / person
Retype split and night shifts into the spreadsheet10–15 min / person
Total overtime, weekends, holidays and leave for payroll5–10 min / person
Total per month – 5 to 8 hours for 10 people30–50 min / person
The most common Excel timesheet mistakes
Spreadsheets break quietly: a formula still shows a number when it is wrong. These are the mistakes we see in companies moving to us from Excel, and how to handle them.
Mistake
What happens in Excel
How the template / Fresh QR handles it
Forgotten clock-out
The day shows 0 hours, or someone types in a guess. Payroll gets a number nobody checked.
The template flags the day. Fresh QR lists it in the pre-payroll checks, and every fix is recorded in the change history.
Night shift across midnight
A plain "out − in" formula returns a negative number or ######.
The template uses MOD, so 22:00–06:00 = 8 h. Fresh QR calculates from the actual scan times.
Overwritten formula
Someone types "8" over the hours formula. The totals stop adding up and nobody knows why.
Formulas sit in white cells, inputs in yellow ones. In Fresh QR, calculations cannot be overwritten.
Typo in a time
7:30 becomes 7.30 or 73:0, and Excel reads it as text or the wrong time.
Data validation only accepts times between 0:00 and 23:59. In the app, the server records the time at the scan.
Break not recorded
Break time is paid as work, or nobody knows whether the break was taken.
The template flags short breaks on shifts over 6 hours. Fresh QR can deduct breaks automatically.
Many versions of one file
"timesheet_final_v2.xlsx" in an email, another copy on a shared drive. Nobody knows which one is right.
The template can't fix this – it is still one file. In Fresh QR everyone works in one system, and employees see their own hours.
Excel timesheet vs attendance app
What you get from a well-built Excel template versus Fresh QR, where employees scan a posted QR code with the free Fresh QR app on their own phone.
Excel (this template)
Fresh QR
Who records the time
The employee on paper, or a manager in the sheet – often after the fact
The employee scans the QR code in the app; the server records the time
€3 per active employee per month, with a monthly minimum of €24, 20% less with yearly billing. 30-day free trial
Pros and cons, honestly
We sell attendance software, so it would be easy to call Excel bad. It isn't. For some teams it is the right choice.
Excel
+Pro: It is free and most companies already have it.
+Pro: You can shape it exactly as you like – columns, codes and formulas.
+Pro: Employees install nothing and don't need a smartphone.
+Pro: Your accountant understands it and it is easy to send on.
−Con: Filling it in by hand is slow and unreliable – people forget, fill in times after the fact, and you often have to chase them just to hand in their timesheet.
−Con: It can't confirm who actually showed up. It records exactly what someone types.
−Con: Edits leave no trace, which makes disputes and labour inspections harder.
−Con: Manual retyping grows with every new person and site – and so do mistakes.
−Con: Employees can't see their own hours or leave balance unless they ask.
Fresh QR
+Pro: Data is collected continuously and reliably: every clock-in and clock-out comes from a QR scan with server time and GPS. Nothing to chase at month-end.
+Pro: Overtime, breaks, leave and holidays are calculated for you.
+Pro: Employees see their own hours and leave on their phone.
+Pro: A printed QR code is enough – no terminal, nothing to mount.
−Con: It costs money: €3 per month for each employee who works at least 40 hours, with a monthly minimum of €24.
−Con: Every employee needs a smartphone and the free Fresh QR app.
−Con: Some people worry about GPS. You need to explain that location is taken only at the scan, not all day.
−Con: You have to set up branches, schedules and rules first. It takes about 10 minutes, not zero.
When you should simply stay with Excel
If you have up to 5 employees in one place, fixed hours and you see them every day, Excel with this template is enough. An app starts to make sense when you add a second site, shifts, part-timers or field work, or when checking timesheets takes more than an hour a month.
Build your own template with AI: a sample prompt
Need different columns, pay rates or a rotating roster? Copy this prompt into ChatGPT, Claude or Copilot in Excel and edit the square brackets. It tells the AI to put formulas in the cells. Change a clock-in time or the month later and the hours update themselves – instead of a sheet with numbers typed in by hand.
Create an .xlsx file for tracking monthly employee attendance (a timesheet).
Company details:
- Country: [United Kingdom]
- Number of employees: [10]
- Contract: [8] hours per day, working days Monday to Friday
- Type of work: [warehouse, two shifts 06:00–14:00 and 14:00–22:00]
- Absence codes: V (vacation), S (sick), TOIL (time off in lieu), BT (business trip), WFH (working from home), U (unpaid)
Sheets:
1. "Settings": year, month (1–12), contract hours per day, minimum break in minutes, a table of absence codes and a list of public holidays in [United Kingdom – England] for the chosen year. Create named ranges.
2. One sheet per employee: rows for days 1 to 31. Columns: date, weekday, clock in, clock out, break in minutes, absence code (drop-down), hours worked, scheduled hours, hours over schedule, check, note.
3. "Summary": hours worked, scheduled hours, overtime, absence counts per code and number of warnings for each employee.
Calculation rules:
- Build the date with a formula from year and month. Leave rows past the end of the month empty.
- Hours worked = (clock out − clock in) − break. Shifts across midnight must be calculated correctly (use MOD).
- Scheduled hours = contract hours on a working day, 0 on weekends and public holidays.
- Check column: warn when clock in or clock out is missing, when the break is below the minimum on a shift longer than 6 hours, when a shift is longer than 12 hours, and when an absence code and hours worked are both entered.
- [Add a weekly total and flag weeks over 40 hours.]
- Highlight weekends and public holidays with conditional formatting.
Technical requirements:
- Use formulas everywhere, not calculated values. No macros.
- Colour input cells yellow and leave formula cells white.
- Data validation: times 0:00–23:59, break 0–600 minutes.
- Don't use XLOOKUP, FILTER or LET, so the file also works in older Excel versions.
- Finally, add a "How to use" sheet with instructions.
Before building the file, summarise your plan in 5 bullet points and ask me if anything is unclear.
How to get a spreadsheet you can actually use
Test the result on three rows you can work out in your head: a normal day, a night shift and a day with a missing clock-out.
Always check public holidays against an official source. Language models often get moving dates such as Easter wrong.
If the AI only returns a table in the chat, ask for an .xlsx file or for Python code using the openpyxl library.
Ask in small steps. "Add a column for night work between 22:00 and 06:00" works better than one long list of changes.
Often yes – most laws require records, not a specific tool. In the EU, the Court of Justice ruled in case C-55/18 (CCOO v Deutsche Bank, 14 May 2019) that employers need an objective, reliable and accessible system to record daily working time; a spreadsheet anyone can edit without a trace is the weak point there. In the US, the FLSA requires hours worked each workday and workweek for non-exempt employees (29 CFR 516.2). Check your local rules.
Use =MOD(clock_out-clock_in,1)*24 and subtract the break in hours. MOD makes a 22:00–06:00 shift return 8 hours instead of a negative number. The "Worked (h)" column in our template already uses it.
We tested it in Microsoft Excel. It only uses common functions (DATE, WEEKDAY, COUNTIF, MOD, INDIRECT), so it should open elsewhere, but drop-downs and conditional formatting may behave slightly differently. Check it against the filled-in example before relying on it.
No. It compares each day with scheduled hours, which suits daily contracts common in Europe. For FLSA weekly overtime, add a weekly sum of the "Worked (h)" column – the AI prompt above includes that line – or let an app calculate overtime from your rules.
You can, but it becomes a separate spreadsheet that never connects to attendance. For the rota we have a free Excel shift schedule template with rest-between-shifts and coverage checks. If you want staff to see the schedule on their phone and the plan to match attendance, see shift planning in Fresh QR.
No. For a small team in one place, Excel is fine. Switching pays off when collecting and checking timesheets takes more than an hour a month, you run several sites, or you need proof that someone was on site. You can try Fresh QR free for 30 days without a credit card and keep your Excel file running alongside.
Yes. Download the monthly timesheet for one or all employees as Excel or PDF in one click – see the guide on exporting timesheets to Excel. Your accountant can keep working with a spreadsheet as before.
Keep the template for as long as it works for you. When timesheets start eating more time than they should, try Fresh QR: a QR code on the wall and the free app on your team's phones. Every clock-in and clock-out records itself, and overtime, breaks and leave are calculated as the month goes – no retyping, no chasing.
The template and this page are not legal advice. Record-keeping rules differ by country; sources cited as of October 2026. Microsoft Excel is a trademark of Microsoft Corporation; Fresh QR is not affiliated with Microsoft.
Need more?
We can help with almost anything
New features, integrations with other systems, custom reports, automation — we can help with all of it.
