• Home
  • Blog
  • Employee time tracking in Excel
Practical guide

Employee time tracking in Excel: a practical 2026 guide

NoBadge answer: Excel works for tracking employee hours in a small team if you use a clear template with formulas for hours, breaks and overtime. Manual timesheets carry an error rate of around 15%, though, so once you pass about 10 employees or several sites, an app that records clock-ins automatically usually costs less than the admin.

Updated October 2026 · 10 min read

Why SMEs still track time in Excel

For many small businesses, a spreadsheet is the first and only time tracking system. It is easy to see why:

  • No extra cost: Excel or Google Sheets is already on every office computer.
  • Familiar: nobody needs training to type a start time into a cell.
  • Flexible: you can shape it around any shift pattern, pay rule or absence type.
  • Easy to hand over: your accountant or payroll provider can open it.

A well-built employee time tracking spreadsheet handles the basics: daily hours, weekly totals, overtime and absences. The typical pattern in a business of 5 to 50 people is a shared workbook, or a template emailed to staff or site managers every Monday and collected on Friday. It works, until the team grows, people work on different sites, or one formula breaks without anyone noticing.

What your spreadsheet needs

Whatever layout you choose, a timesheet that will stand up at payroll time needs the following columns. Our free timesheet Excel template uses exactly this structure, in weekly, monthly and yearly views.

ColumnWhat it recordsWhy it matters
Date and employeeOne row per person per dayLets you filter, total and audit by person and period
Site or projectWhere the work was doneNeeded for multi-site teams, client billing and job costing
Start and finishTimes in hh:mm formatThe raw data every other figure depends on
BreakUnpaid break in minutesDeducted from paid hours; shows rest breaks were taken
Hours workedCalculated by formulaNever typed by hand, so it cannot drift from the times
Contracted hours and overtimeDaily or weekly threshold, hours above itDrives overtime pay and highlights long weeks
Absence codeAnnual leave, sick, public holiday, unpaidFeeds holiday balances and payroll
ApprovalManager initials and dateShows who checked the week before it went to payroll

How to set it up, step by step

Plan about half an hour for the first set-up. These steps work in both Microsoft Excel and Google Sheets.

1. Create one log, not one file per person

Use a single sheet called "Log" with one row per employee per day and the columns above. Separate files per employee are the main source of version chaos. If you need a view per person, build it with filters or summary formulas.

2. Calculate hours with a formula that handles night shifts

With start time in D, finish in E and break minutes in F, hours worked are =MOD(E2-D2,1)*24-F2/60. The MOD part makes a shift from 22:00 to 06:00 come out as 8 hours instead of a negative number. Format the result as a number with two decimals so it adds up cleanly.

3. Add overtime and weekly totals

With contracted daily hours in H, daily overtime is =MAX(0,G2-H2). For weekly totals per person, use SUMIFS on the log, for example the hours for one employee between two dates. Keep overtime rules (daily or weekly threshold) written at the top of the sheet so everyone applies the same one.

4. Restrict what can be typed

Use data validation for the absence code column (a drop-down list) and for times. Then protect the formula columns: in Excel via Review, Protect Sheet; in Google Sheets via Data, Protect sheets and ranges. This alone prevents a large share of payroll errors.

5. Flag long weeks

Add conditional formatting that colours weekly totals above a threshold you choose. In the UK, the Working Time Regulations limit average weekly working time to 48 hours over 17 weeks unless a worker opts out, so a weekly flag is a useful early warning, not the legal test itself.

6. Decide who fills it in and when

Either employees enter their own times in a shared Google Sheet with protected ranges, or a manager fills it centrally each day. Daily entry is far more accurate than reconstructing a week on Friday afternoon.

7. Export for payroll and archive

At month end, filter the log to the period, check and approve it, then export to PDF or CSV for your payroll provider. Keep the approved file in a folder with restricted access.

Excel or Google Sheets?

Both work with the formulas in this guide. Google Sheets is easier to share: there is one file in the browser, a version history and per-range protection, so employees can enter their own times without touching the formulas. Excel is more familiar to many accountants and works offline, but sharing a desktop file usually means emailing copies, which is exactly how versions multiply. If you choose Excel, keep the workbook in one shared location with controlled access so that everyone edits the same file.

One limit applies to both: in a single shared sheet, every editor can see everyone's rows. You cannot easily let each employee see only their own hours while managers see their whole team. That is one of the reasons growing teams move to an app with separate roles for admins, managers and employees.

Seven common Excel timesheet mistakes

  • Typing totals by hand instead of calculating them from start and finish times.
  • Minus signs on night shifts because the formula does not handle midnight.
  • Mixing decimal hours and hh:mm: 7.30 is not seven and a half hours.
  • One file per person, emailed back and forth, with nobody sure which version is final.
  • Unprotected formulas that someone overwrites while correcting a typo.
  • Hours written up from memory at the end of the week.
  • Files on personal laptops or in open shared drives, which is a data protection problem as much as an accuracy one.
Manager clocking in on a smartphone with NoBadge instead of filling in an Excel timesheet

From spreadsheet to live dashboard

NoBadge records clock-ins from each employee's smartphone by GPS or dynamic QR code, totals hours and overtime automatically and still gives your accountant an Excel file, in one click.

The real cost of manual time tracking

Excel has no licence cost, but the time around it is not free. For a business with 20 to 30 employees, the hidden costs add up quickly:

Cost itemExcel or paperNoBadge
Admin timeAbout 10 hours a week collecting, checking and totalling2–3 hours a week, mostly reviewing exceptions
Error rateAround 15% of manual timesheets contain errorsTimes recorded at the tap, with position; no retyping
Payroll mistakes€1,500–€2,000 a yearHours and overtime calculated automatically
Total admin cost€12,000–€14,000 a yearAround 70% less admin time
Proof of presenceNone: the sheet shows what was typedGPS position at clock-in or dynamic QR code on site
Software cost€0€5,04 per active user per month; the total varies with who clocks in

NoBadge pricing follows your team: if 10 employees clock in this month you pay for 10, if only 2 clock in next month you pay for 2, and if nobody clocks in you pay €0. There is no hardware, whereas a single badge terminal costs €800–€2,000.

NoBadge typically pays for itself in under 30 days for a 20–30 person team, because cutting about 10 hours of weekly admin to 2–3 hours is worth far more than the subscription.

Payroll accountant comparing paper timesheets with the hours in a spreadsheet on her laptop

Excel timesheets and the law

No law forbids spreadsheets. What the law cares about is whether your records are adequate, accurate and secure.

Working time records

In the UK, the Working Time Regulations 1998 require records adequate to show that the 48-hour average limit and night-work limits are respected, kept for two years. Across the EU, the Court of Justice's 2019 ruling in case C-55/18 requires an objective, reliable and accessible system for recording daily working time, implemented differently in each country. A spreadsheet can meet these requirements, but a file anyone can edit after the fact, with hours typed from memory, is weak evidence in a dispute. Our Working Time Regulations UK guide explains what "adequate records" means.

Data protection

Time records are personal data under GDPR and the UK GDPR. A workbook emailed around, saved on personal laptops or left in an open shared folder is hard to reconcile with the security and storage limitation principles. Restrict access, set a retention period and delete old files when it expires. Read more in GDPR and employee time tracking.

Six signs you have outgrown Excel

  1. You have 10 or more employees. Collecting and checking 10+ timesheets every week becomes a part-time job.
  2. Your team works on several sites. A spreadsheet cannot show where someone actually was when they started. A GPS time clock records the position at clock-in and checks it against the site's geofence.
  3. Leave requests arrive everywhere. WhatsApp, email and sticky notes lead to clashes and wrong balances. A leave management tool keeps requests, approvals and balances together.
  4. Pay queries are increasing. If employees regularly question their hours, the data is not trusted.
  5. You worry about compliance. Records reconstructed at the end of the week are hard to defend.
  6. Month end takes a whole day. If preparing hours for payroll takes more than a couple of hours, the spreadsheet is costing you money.

Moving from Excel to an app

Switching does not mean changing your payroll process: NoBadge exports the same kind of Excel file your accountant already uses. The difference is that the data is collected at the moment people start and finish work.

  1. Create your account. No credit card, 15-day free trial, ready in about 2 minutes.
  2. Add your sites and team. Set a geofence for each site and invite employees by WhatsApp or email link.
  3. Clock in from the phone. NoBadge runs in the browser of any Android phone or iPhone, with no app store download. Employees clock in by GPS or by scanning a dynamic QR code that changes every few seconds.
  4. Export for payroll. Hours, overtime and absences are totalled automatically and exported to Excel in one click.

A sensible approach is to run both in parallel for one pay period, compare the totals, then retire the spreadsheet. Keep the old files for as long as your record-keeping rules require.

"We simplified attendance management for teachers, tutors and admin staff across multiple sites. We save hours every week compared to the old Excel sheets." — Claudio Querelante, Director, Accademie AIEM

FAQ

Excel time tracking: frequently asked questions

For a small team on fixed hours at one site, often yes, provided hours are calculated by formula and entered daily. Beyond about 10 employees, several sites or variable shifts, manual entry errors of around 15%, version conflicts and roughly 10 hours a week of admin make a spreadsheet more expensive than it looks.

At minimum: date, employee, site or project, start time, finish time, unpaid break, hours worked calculated by formula, contracted hours, overtime, an absence code and a manager approval. Keep everything in one log with one row per person per day, and protect the formula columns so they cannot be overwritten.

With start time in D, finish time in E and break minutes in F, use =MOD(E2-D2,1)*24-F2/60. MOD handles shifts that cross midnight, so 22:00 to 06:00 gives 8 hours instead of a negative value. Format the result as a number, then add overtime with =MAX(0,G2-H2) against contracted hours in H.

It can be. The Working Time Regulations 1998 do not prescribe a format; records must be adequate to show compliance with the 48-hour average and night-work limits and be kept for two years. The weak point of a spreadsheet is reliability: hours typed from memory and editable files are hard to defend if a dispute arises.

€5,04 per active user per month, all features included, with no hardware. The monthly total varies: if 10 employees clock in you pay for 10, if 2 clock in next month you pay for 2, and with nobody clocking in you pay €0. Excel has no licence fee, but manual admin costs a 20–30 person business €12,000–€14,000 a year.

Yes. NoBadge exports hours, overtime and absences to Excel in one click, so your accountant or payroll provider receives the same kind of file as before. What changes is how the data is collected: employees clock in on their smartphone by GPS or QR code instead of typing times into a sheet.

Start today

Stop chasing spreadsheets. Let your team clock in from their phones.

Create your account, invite your team and see the first clock-in in under 2 minutes. Free trial, no credit card, no hardware.

No contract · Cancel anytime · EU hosted · GDPR compliant

English Deutsch Español Français Română