Free Weekly Timesheet Template (Excel and PDF)
Here's a weekly timesheet that does the math for you: daily hours from clock-in, clock-out, and break minutes, a weekly total, and a regular-versus-overtime split at 40 hours. No email required, no watermarks. Use it as long as it's useful.
JULY 28, 2026 · BY THE CLOX TEAM
Here's a weekly timesheet that does the math for you: daily hours from clock-in, clock-out, and break minutes, a weekly total, and a regular-versus-overtime split at 40 hours. No email required, no watermarks. Use it as long as it's useful.
01
How to use it
- One row per day. Enter time in, time out, and break minutes; the Hours column computes itself.
- The Job column is optional but worth the habit: even one word per day tells you where the week went.
- The Total row sums the week, and the Regular and Overtime rows split it at 40 hours automatically.
- Print the PDF version for a clipboard crew; the columns match, so someone in the office can type it into the Excel copy in a minute or two.
02
The two mistakes this template prevents
Break math. Most spreadsheet timesheets ask people to subtract lunch in their heads, and people round in their own favor without meaning to. Entering break minutes as a number and letting the formula subtract them removes the daily estimating.
Forgotten overtime. A plain total hides the 40-hour line. Splitting regular and overtime on the sheet itself means nobody discovers OT for the first time on payday. If overtime keeps surprising you anyway, our overtime pay calculator shows the dollars, and the timesheet rounding rules guide covers the minutes.
03
When a spreadsheet stops working
A template is the right tool up to the point where the problems become collection problems rather than math problems: timesheets arriving late, hours that don't match who was on site, one sheet per person per week multiplying into a folder nobody audits. A spreadsheet can't tell you a punch happened at the job site, can't stop a Tuesday entry written on Friday from drifting, and can't export itself to payroll.
That's the point where software is worth paying for. Clox gives every worker a one-tap clock in from their phone, blocks off-site punches by geofence, shows every clock-in on a map of your job sites, and turns the approved week into the exact file QuickBooks, Gusto, ADP, or Paychex expects. Pricing is one line: $29 a month includes 3 users, then $6 per user.
04
FAQ
Is this template really free?
Does it handle overtime over 40 hours?
Excel or Google Sheets?
When the spreadsheet becomes the problem, Clox is $29 a month for the whole crew. Free for 14 days, no credit card.