Free employee timesheet template (auto-calculating)
Most free timesheets are just empty grids — you still do the time math by hand, and 7:45-to-4:15-minus-lunch is exactly the arithmetic people get wrong. This one calculates: type the times, and daily hours, period totals, and the overtime split fill themselves in.
Download free templateExcel (.xlsx) · auto-calculating hours · opens in Excel & Google Sheets · No signup required
What’s inside
A two-week grid: date, day, clock in, break out, break in, clock out
A daily-hours column that computes (clock out − clock in) − break, automatically
Total, regular, and overtime rows with live formulas
Three sample rows (including a no-break shift) showing the time format
How to use this template
Download the timesheet
Open the .xlsx in Excel or import into Google Sheets — the hour formulas carry over.
Fill in the header
Employee name and the pay period the sheet covers.
Enter times daily
Type times as h:mm AM/PM (e.g. 9:00 AM). Leave break columns empty for shifts without a break; the formula handles it.
Read the totals
Daily hours, period total, and the regular/overtime split calculate as you go — no calculator, no “minutes as decimals” conversion errors.
Reconcile before payroll
Have the employee confirm the totals, then carry them into payroll — or let EpicShifts time tracking build the timesheet from real clock-ins, with disputes handled in-app.
When to use it
Use this when employees track their own hours — small teams without time clocks, contractors, or anywhere paper timesheets still circulate. The formulas remove the most common payroll error (hand-added hours), but a self-reported timesheet still can’t tell you whether the times themselves are right, and its overtime row uses the simple over-80-per-two-weeks view. US federal overtime is per workweek (over 40 in each week), so split the weeks for exact payroll — or use time tracking that applies the rules automatically.
Skip the spreadsheet
Already filled it in? Upload the file to EpicShifts and we’ll import it into a live schedule — your team sees their shifts on mobile, swaps and picks up open shifts, and gets reminders automatically.
Frequently asked questions
How do I calculate hours worked on a timesheet?
Hours worked = (clock out − clock in) − unpaid break time. In this template that formula is built in: enter times as h:mm AM/PM and the daily-hours column converts the difference to decimal hours automatically, which is what payroll systems expect.
Does this timesheet handle overtime?
It shows total hours and splits out anything over 80 for the two-week period as a quick check. Note that US federal overtime is calculated per workweek — over 40 hours in each week separately — so for exact payroll, apply the split per week or use software that does it for you.
Do the formulas work in Google Sheets?
Yes. The time subtraction and SUM/MIN/MAX formulas are standard and work in both Excel and Google Sheets. Import via File → Import → Upload and enter times in the same h:mm AM/PM format.
Dustin Hanke, Founder, EpicShifts — Dustin builds EpicShifts and writes about scheduling, labor cost, and shift-work operations for restaurants and other hourly teams.
We Value Your Privacy
We use cookies to improve your experience on our platform. Essential cookies are required for the site to function properly (authentication, security). Optional cookies help us understand how you use the site and improve our services. Learn more about cookies