Excel Timesheet Template: Build From Scratch With Formulas, Overtime, and Free Downloads

What an Excel Timesheet Actually Is (and Why People Still Build Them)

An Excel timesheet template is a spreadsheet that records when an employee or contractor starts work, when they stop, and what those hours add up to. The math is simple. The reason it keeps showing up in payroll inboxes is that everyone already has Excel, and a clean two-column time grid beats most paid trackers for small teams.

You will see two flavors in the wild. The first is a printable PDF — a grid the employee fills in by hand, then signs. The second is the live spreadsheet, where formulas total weekly hours, separate overtime, and feed payroll. This guide covers the second one, but it builds from the same column structure as the paper version.

Before you copy a stranger's file, know what you actually need. A weekly timesheet for a 5-person shop is not the same artifact as a biweekly billing log for a freelance designer. Get the columns right first. The formulas come after.

Columns Every Excel Timesheet Needs

Skip the columns and you will rebuild the file in three weeks. Build them once, build them right. Here is the standard eight-column layout that handles 90% of small-business cases:

Date (A) — calendar date. Day (B) — Mon, Tue, Wed... auto-fill with =TEXT(A2,"ddd") if you want it derived from the date. Start Time (C) — 8:00 AM. End Time (D) — 5:00 PM. Break (E) — usually expressed in hours or minutes, paid or unpaid depending on policy. Hours Worked (F) — the calculated total. Overtime (G) — anything past the daily or weekly threshold. Notes (H) — for client codes, sick time, or jobsite IDs.

You can add a column for pay rate if the rate varies by day or by project. For a salaried team that does not need rate columns, drop them and keep the sheet narrow enough to print on one page. Wide timesheets that scroll horizontally lose information when managers review them on a phone.

Format the time cells as time, not as numbers. Highlight C2:D2, hit Ctrl+1 (Format Cells), pick Time, choose h:mm AM/PM. If you type "8:00" and Excel shows "8:00:00 AM" — perfect. If it shows "0.333333" — your cell format is wrong and every formula downstream will break.

The Three Core Time Formulas You Need

Excel stores time as a fraction of a day. 12:00 noon is 0.5. 6:00 AM is 0.25. This matters because subtraction gives you a fraction, not a count of hours, and that fraction has to be interpreted before payroll can see it.

The first formula is the raw time difference. In F2 type =D2-C2 and format the cell as time h:mm. If the employee worked 8:00 to 5:00, you get 9:00 — nine hours including lunch. Subtract the break: =D2-C2-E2 where E2 is "0:30" formatted as time. Now F2 shows 8:30, the paid hours.

The second formula converts that time fraction into a decimal so payroll software can multiply it. =(D2-C2-E2)*24 turns 8:30 into 8.5. Format the cell as Number with two decimals. This is the column you export to QuickBooks, Gusto, or whatever runs payroll. Payroll does not understand "8:30" — it needs 8.5.

The third formula handles overtime at the daily level. In G2 use =IF(F2>8, F2-8, 0) if you are tracking time as a decimal, or =IF((D2-C2-E2)*24>8, (D2-C2-E2)*24-8, 0) if F2 is still a time-format cell. This flags anything above 8 hours per day as overtime. California uses 8/day. Most other states use 40/week — we cover that next.

Weekly Totals and the 40-Hour Overtime Rule

The federal overtime rule under the Fair Labor Standards Act is simple in one line and messy in practice: anything over 40 hours in a workweek is overtime at 1.5x the regular rate. Daily overtime only kicks in for specific states (California, Alaska, Nevada, Colorado, and a few others) and specific industries.

For a weekly total, put =SUM(F2:F8) in F9 if you have seven daily rows. If F is time-formatted, the result will roll over at 24 hours — 41 hours displays as 17:00. That is the rollover trap. To stop it, custom format the total cell as [h]:mm with brackets around the h. The brackets tell Excel to count hours past 24 instead of resetting to zero.

For weekly overtime use =IF(SUM(F2:F8)*24>40, (SUM(F2:F8)*24)-40, 0). This gives you only the overtime hours for the week as a decimal. Regular hours becomes =IF(SUM(F2:F8)*24>40, 40, SUM(F2:F8)*24) — capped at 40. Multiply each by the relevant rate (regular and OT) and you have gross pay for the week.

If you want both daily and weekly overtime tracked separately, build a small helper table at the bottom. Column G holds daily OT. Cell H10 holds weekly OT computed against the SUM. The greater of the two is what gets paid for the week. Combining both rules into one formula gets ugly fast, so split it.

Custom Time Formats and the Rollover Trap

The single most common Excel timesheet bug is total hours rolling over at 24. Someone builds a weekly sheet, the total reads 16:00, and they cannot figure out why a team that obviously worked 40 hours shows two-thirds of a day. The fix takes ten seconds once you know it.

Right-click the total cell. Format Cells. Custom category. In the Type box, type [h]:mm with the square brackets. Click OK. Now 40 hours displays as 40:00, 56 hours as 56:00, 168 hours (the maximum in a week) as 168:00. The brackets are the entire trick. Without them, Excel treats the value modulo 24.

The same custom format works for monthly totals where you might cross 160 hours. It works for project tracking sheets that accumulate across weeks. Anywhere a sum of times exceeds one day, you need the bracketed format. Most templates from Microsoft and Vertex42 already include this — when you build from scratch, you have to apply it yourself.

Employee Info, Signatures, and Print Layout

Above the daily grid, dedicate four merged rows for header data: employee name, employee ID, department or job site, supervisor, week ending date, and pay period. Most payroll auditors expect this block. If you are ever audited under the FLSA, you need to prove which week the records cover and who signed off.

Below the grid, two signature rows: one for the employee certifying the hours are accurate, one for the manager approving them. Leave a dated line under each signature. Some companies require a witness signature too — overkill for a 5-person business, standard for federal contractors.

For print, set the print area to A1:H12 (or wherever your grid ends). File → Page Setup → Page tab. Pick Landscape, then Fit to 1 page wide by 1 tall. Under the Sheet tab, check Gridlines so the printed page shows the cell boundaries. Print Preview before saving. A timesheet that prints across three pages will end up filed in chunks and lost.

Freeze the header row so it stays visible as you scroll. Select row 2, View → freeze panes in excel, Freeze Top Row. The column headers (Date, Day, Start Time, etc.) stay locked while you scroll through 30 days of entries. Trivial feature, daily quality-of-life win.

Biweekly and Monthly Variants

The weekly template scales up cleanly. For biweekly, copy the weekly grid below itself, label one Week 1 and the other Week 2, and put a grand total at the bottom that sums both weeks separately for overtime — you cannot just SUM all 14 days, because overtime is calculated per week, not per pay period. The IRS and Department of Labor are both clear on this.

Build two weekly subtotals (F9 for week 1, F18 for week 2). Calculate overtime against each independently using the 40-hour formula above. Sum the two regular-hour totals and the two overtime totals separately. Your pay period totals at the bottom should show: Regular hours, Overtime hours, Gross pay (regular × rate + OT × rate × 1.5).

Monthly templates are different animals. They typically have 31 daily rows, with a 4-week or 5-week breakdown depending on the month. The overtime math gets complicated when a week splits across two months — most monthly templates ignore overtime entirely and let payroll handle it from the daily decimal hours. For salaried staff this is fine. For hourly staff, biweekly is the safer template.

Pay Rate and Gross Pay Calculations

Add a Pay Rate cell in the header (call it B3). Then a Gross Pay calculation at the bottom. Regular pay is =Regular_Hours*B3. Overtime pay is =OT_Hours*B3*1.5. Total gross is the sum. If the rate ever changes mid-pay-period, switch to a per-row rate column and the math stays clean.

For contractors billing different rates by client, use a Client column and a VLOOKUP to a rate table. The rate table sits on a second sheet — Client A: $75, Client B: $90, Client C: $125. Each row pulls the right rate based on what the contractor entered. This is the template most freelance designers and consultants actually use, because they juggle hourly billing across multiple clients and need defensible invoices.

If you want a fast formula reference, the SUM formula in Excel covers the basic weekly total, and combining it with conditional formatting in excel can flag overtime rows in red automatically. Both are core skills for any timesheet maintainer.

Saving, Sharing, and Cloud Sync

Save the master template as .xltx (Excel Template), not .xlsx. When you double-click an .xltx file, Excel opens a copy. The master stays clean. Every new pay period, open the template, fill it out, save the filled version as Timesheet-LastName-WeekEnding-MMDD.xlsx in a shared folder.

If you store the file in OneDrive or SharePoint, turn on AutoSave. Two people editing the same file at once — say the employee filling in hours and the manager approving them — get live collaborative editing. Without AutoSave, you risk overwriting each other's edits when one of you uploads a local copy. This is the single most useful Excel feature for distributed teams.

For files that get emailed back and forth instead, lock the formula cells. Select F2:G8, hit Ctrl+1, Protection tab, check Locked. Then Review → Protect Sheet. Now the employee can type into start, end, break, and notes columns, but cannot accidentally delete the formula that calculates their pay. This is the difference between a template that survives six months and one that breaks in week three.

Where to Find Good Free Templates (Microsoft, Vertex42, Smartsheet, Google Docs)

You do not have to build from scratch. Several legitimate sources ship Excel timesheet templates that already handle the formulas, overtime logic, and print layout. Here is what is actually worth downloading:

Microsoft Office templates are bundled with every Excel install. File → New → search "timesheet" — you get a dozen weekly, biweekly, and monthly variants. The formulas are conservative but correct. The visual design is dated. Good as a starting point if you want zero risk.

Vertex42 publishes the most-used free timesheets on the open web. Their weekly time card, biweekly time tracker, and project time log are all single-file downloads with no signup. Formulas are visible and editable. License allows commercial use. This is what most accountants and bookkeepers recommend for small businesses.

Smartsheet offers free Excel downloads from their template gallery, though the heavy push is toward their paid platform. The Excel files themselves are clean, with separate tabs for employee details and weekly time entries. Useful if you want a more modern visual style.

Google Docs / Google Sheets hosts community templates that download as Excel-compatible .xlsx files. Quality varies — pick ones with high ratings. The Sheets-native versions sometimes have formulas that do not survive the conversion to Excel, so test before deploying to your team.

Industry-Specific Variations: Construction, Retail, Freelance

The generic weekly template works for office workers. Other industries need fields that the generic template skips. Construction needs job codes per row — an employee might split a day across three jobsites and each chunk gets billed to a different project. Add a Job Code column between Notes and Hours Worked. Total hours per job code at the bottom using =SUMIF(JobCodeColumn, "JOB123", HoursColumn).

Retail needs a Shift column (morning, mid, close) because labor cost analysis happens by shift, not by employee. Add a Shift column and use a pivot table on the monthly file to see which shifts are over budget. Most retail managers also track meal breaks separately from rest breaks because California law requires it.

Freelance needs a Client column and a Project column. The contractor bills hourly across multiple clients, often at different rates. The timesheet doubles as an invoice source. Build a separate tab that filters the main timesheet by client and date range, then totals it with rates pulled via VLOOKUP. Export the filtered tab as PDF and you have an invoice ready to send.

Common Formula Mistakes (and How to Fix Them)

Mistake one: time cells display as decimals like 0.333. The cells are formatted as Number. Highlight them, Ctrl+1, Format Cells, Time. Done.

Mistake two: weekly total shows 16:00 when you obviously worked 41 hours. The rollover trap. Format the total cell as [h]:mm — the brackets are the fix.

Mistake three: end time before start time (an overnight shift) gives a negative result. Use =MOD(D2-C2,1) instead of =D2-C2. The MOD function wraps the calculation around midnight correctly.

Mistake four: SUM returns zero even though all cells have numbers. Usually a text-vs-number mismatch — the employee typed "8.5h" instead of 8.5. Excel sees text. Strip the letter or use =VALUE() to coerce.

Mistake five: overtime formula returns the wrong amount. Almost always because the formula is built against a time-format cell (0.354) instead of a decimal cell (8.5). Multiply by 24 first, then compare to the threshold.

Mistake six: managers complain the sheet is hard to scan. Apply alternating row colors with conditional formatting and bold the header row. A two-minute fix that turns a wall of numbers into a readable document.