Timesheet Template: Exact Columns, Formulas, and Examples

A timesheet template needs seven columns: date, day, time in, time out, break, daily hours, and notes, plus a weekly summary row that splits regular hours from overtime. This guide gives you a copyable weekly layout, the exact spreadsheet formulas, and the decimal trap that quietly shorts paychecks.

Most of the free timesheet template files floating around the internet fail on the math, not the layout. They total hours across two weeks when federal overtime is weekly, or they let people type "8.30" for eight and a half hours and nobody notices until an employee does. Both mistakes cost real money. Both are fixable in ten minutes with the right structure, so let's build it.

The exact columns every timesheet template needs

Left to right: Date, Day, Time In, Time Out, Break (minutes), Daily Hours, and Notes. At the bottom, three summary cells: Regular Hours, Overtime Hours, and Total Hours for the week. The header carries the employee's name, the pay period dates, and signature lines for the employee and a supervisor. Those signatures look old-fashioned. Keep them anyway, because a signed timesheet is your best exhibit if hours are ever disputed.

Here's a filled example you can copy for any weekly template for timesheet tracking. The same timesheet layout works printed on a clipboard or typed into a spreadsheet, which is why it's worth getting right once:

Date	Day	Time In	Time Out	Break (min)	Daily Hours	Notes
6/15	Mon	8:00 AM	4:45 PM	30	8.25
6/16	Tue	8:00 AM	4:15 PM	30	7.75
6/17	Wed	7:30 AM	4:15 PM	30	8.25	Early delivery
6/18	Thu	8:00 AM	6:00 PM	30	9.50	Covered for Dan
6/19	Fri	9:00 AM	4:15 PM	30	6.75
Weekly totals					40.50	40 regular, 0.5 OT

If your team takes a single unpaid lunch, one Break column in minutes is enough. If people step out and back in for breaks, use four time columns instead: Morning In, Lunch Out, Lunch In, Evening Out. One federal rule shapes how you handle that column either way. Short rest breaks of 5 to 20 minutes count as paid hours worked under 29 CFR 785.18, so never deduct them. A bona fide meal period of 30 minutes or more, where the employee is fully relieved of duty, can be unpaid under 29 CFR 785.19. Your Break column should only ever contain the second kind.

Resist adding pay rates to the sheet itself. Timesheets get printed, emailed, and left on desks. Keep the hours here and the money in payroll.

One layout serves nearly everyone. A timesheet template for small business use doesn't need project codes, department splits, or billing rates unless you actually invoice by the hour. Every extra column is one more place to make a mistake, and a timesheet template for employees to fill in by hand should fit on a single page without shrinking the font to six points.

Should your timesheet template be weekly, biweekly, or monthly?

Match the timesheet to your pay period, with one exception explained below. A weekly timesheet has seven day rows plus a totals row, and it's the cleanest format because federal overtime is calculated per workweek. Under 29 USC 207, hours over 40 in a workweek are owed at not less than one and a half times the regular rate, so the entire overtime calculation lives on one sheet.

A biweekly timesheet template covers 14 days, but it must keep the two workweeks visually separate with a subtotal after each. You cannot average the two weeks. The regulation at 29 CFR 778.104 says it plainly: the FLSA "takes a single workweek as its standard and does not permit averaging of hours over 2 or more weeks." An employee who works 45 hours in week one and 35 in week two is owed 5 overtime hours even though the total is exactly 80.

Monthly and semimonthly formats are the trickiest, because workweeks straddle the start and end of the period. If you pay semimonthly, keep weekly timesheets anyway and map them to pay periods at payroll time. That's the exception to the match-your-pay-period rule, and it saves genuine headaches.

Structure	Rows	Overtime math	Best for
Weekly	7 days + totals	Self-contained, simplest	Weekly pay, hourly crews
Biweekly	14 days, subtotal per week	Two separate weekly calcs	Biweekly payroll
Semimonthly / monthly	15 to 31 days	Workweeks straddle periods; needs running weekly totals	Salaried-heavy teams

Formulas for an Excel timesheet template that adds up

Enter times as real time values (9:00 AM, 5:30 PM), never as text. With Time In in B2, Time Out in C2, and break minutes in D2, the daily total formula is =(C2-B2)*24-D2/60, formatted as a plain number. Spreadsheets store times as fractions of a day, so multiplying by 24 converts the difference to decimal hours. In at 8:00 AM, out at 4:45 PM, 30-minute lunch: (16.75 - 8.00) - 0.5 = 8.25 hours. The same formula works whether you build a timesheet template in Excel, a timesheet xls template you email around, or a Google Sheet. We walk through the Sheets version step by step in our Google Sheets timesheet template guide.

Two more formulas finish the job. Overnight shifts break the basic subtraction because Time Out lands "earlier" than Time In, so use =MOD(C2-B2,1)*24-D2/60 instead; a 10:00 PM to 6:00 AM shift then correctly returns 8 hours. For the weekly summary, Regular Hours is =MIN(TotalHours,40) and Overtime is =MAX(TotalHours-40,0). That MIN/MAX pair caps regular time at 40 and pushes the rest into overtime, exactly matching the federal workweek rule.

Then protect the formula cells. In Excel that's Review, then Protect Sheet after unlocking only the input columns; in Sheets it's Data, then Protect sheets and ranges. Employees can type times and nothing else. This one step eliminates most "the spreadsheet is broken" emails, because the usual cause is someone overwriting a formula with a hand-typed number. When you want to check a week fast without a spreadsheet at all, our free timesheet calculator does the same math in the browser.

Google Sheets, Google Forms, and other free options

A google sheet timesheet template gives you those same formulas with sharing built in, so a supervisor can watch the week fill in instead of waiting for a file to land in their inbox on Monday. Set it up as one tab per employee, or one tab per pay period with a name column, and share it with edit access limited to the input range. Anyone hunting for a google spreadsheet timesheet template usually wants exactly that: the math from the section above, plus a link they can send.

A google form timesheet template is the variant worth knowing about. Employees submit a short form from a phone (date, time in, time out, break minutes), and Forms writes each response as a row in the linked sheet where your formulas run. Nobody touches a formula cell, ever. The tradeoff is that responses are still typed from memory, so you get clean data entry rather than real timestamps.

If payroll already runs in QuickBooks, keeping the timesheet in QuickBooks puts hours and paychecks in one place, though the weekly timesheet feature sits behind the paid tiers. Whichever tool you land on, decide up front whether an electronic timesheet replaces the paper one or just shadows it. Running both leaves you with two records that disagree, and they only ever disagree in front of someone asking questions. Set the timesheet print area while you're in there too: one week per page, gridlines on, so a signed printout matches what's on screen.

The 8:30 vs 8.50 decimal mistake

The single most common timesheet error is treating minutes as decimals. Eight hours and 30 minutes is 8.5 hours, not 8.30. Someone who types 8.30 for an 8.5-hour day shorts that day by 12 minutes. Small number. It compounds fast: at $20 an hour that's $4 a day, $20 a week, and about $1,040 across 260 workdays a year, per employee. Run it the other direction and payroll systems expecting decimal hours will read a written "8.30" as 8 hours 18 minutes, so the error bites both ways.

How do you convert minutes to decimal for payroll?

Divide the minutes by 60 and keep two decimal places. Payroll systems want decimal hours, people write minutes, and the gap between those two habits is where the money leaks out:

Minutes	Decimal hours	Common mistake
15	0.25	written as 0.15
20	0.33	written as 0.20
30	0.50	written as 0.30
45	0.75	written as 0.45

If your template uses real time values and the formulas above, the spreadsheet does the conversion for you, which is exactly why typed-in decimal hours are the riskier design. Label the totals column "Hours (decimal)" so nobody guesses, and keep a minutes-to-decimal converter bookmarked for the stragglers who still write 8.30.

Rounding rules: what a timesheet may and may not do

Plenty of templates round punch times to the nearest quarter hour, and federal law allows it within limits. Under 29 CFR 785.48, recording start and stop times to the nearest 5 minutes, one-tenth of an hour, or quarter hour is accepted, provided the practice doesn't fail "to compensate the employees properly for all the time they have actually worked" over time. Translation: rounding must cut both ways. A template that always rounds clock-ins up and clock-outs down systematically shorts people, and that's exactly the pattern wage lawsuits look for.

If you round, round neutrally. Nearest quarter hour means 8:07 becomes 8:00 and 8:08 becomes 8:15, in the employee's favor as often as yours. And honestly, rounding made sense when someone had to hand-total a stack of paper cards. A spreadsheet doing the math in decimals gains nothing from it, so the simplest compliant policy for a template is no rounding at all: record actual minutes, let the formulas convert.

Three other mistakes worth designing out of your template while you're at it:

• Auto-deducting lunches that didn't happen. If the template subtracts 30 minutes every day by default, the day someone works through lunch becomes an underpayment. Make the break column an entry, not a constant.
• Totaling the pay period instead of the workweek. Overtime lives at the week level. A period-level total hides a 45/35 split that owes 5 hours at time and a half.
• Letting "close enough" times stand. Five employees writing 9:00 to 5:00 every single day is a signal the sheet is being reconstructed from memory, not recorded. Signed fiction is still fiction, and it's weak evidence in a dispute.

How do I fill out a timesheet without making work for someone else?

Record the punch when it happens, not on Friday afternoon. Write the real clock-in time, the real clock-out time, and the actual break minutes, then let the sheet calculate hours worked from those three inputs. If anyone is typing a daily total by hand, the template isn't finished. Use the notes column on any day that looks odd (a covered shift, a skipped lunch, an early delivery), because that one line is what answers the question that surfaces three months later.

Submit the timesheet weekly even when payroll runs every two weeks. Weekly submission matches how overtime is actually calculated, corrections stay small, and whoever has to calculate timesheet totals for the crew isn't doing 14 days of arithmetic in one sitting. Then sign it. An unsigned sheet is an assertion. A signed one is a record both sides agreed to at the time.

Chasing sheets is the part nobody budgets for. A standing timesheet reminder on Thursday afternoon, plus a second one an hour before payroll closes, collects most of what would otherwise land late. We covered the wording and the cadence in our guide to timesheet reminders.

What is the easiest way to add up time cards?

Let something else do the arithmetic. A work hours calculator, a protected spreadsheet, or a time clock all beat mental math over a stack of cards at 6pm. For a single week, a clock in and clock out time calculator handles the decimal conversion and the 40-hour split in one pass. For fifty employees, that's the point where timesheet software pays for itself, because manual totaling scales with headcount and your patience doesn't.

Printable, spreadsheet, or time clock: which format fits?

Printable timesheets still earn their keep for tiny crews, job sites without reliable devices, and anywhere a clipboard is honestly faster. Their weaknesses are just as real: handwriting disputes, zero math checking, retyping into payroll, and the Friday reconstruction where everyone "remembers" working exactly 8 hours every day. A digital template fixes the arithmetic but not the memory problem, because people still fill it in after the fact.

Format	Math errors	Real timestamps	Payroll entry	Cost
Paper timesheet	Frequent, manual	No	Retyped by hand	Printing only
Spreadsheet template	Rare if formulas protected	No, self-reported	Copied over manually	Free
Free time clock app	None, computed	Yes, punch-level	Exported automatically	Free (Kloqk)

The step up from any template is a time clock, where employees punch in and out in real time and the timesheet builds itself from actual timestamps. That removes the arithmetic and the end-of-week guesswork in one move. Price used to be the spreadsheet's trump card, but Kloqk's time clock is free for unlimited punches, so the honest comparison is now about effort, not dollars. Keep a paper backup for power outages. Let software do the daily work. If you'd rather skip the file entirely, a timesheet template app builds the same seven columns from real punches and hands you the finished total.

A middle path if you're not ready to switch: keep your template, but run each week's numbers through our free time card calculator to catch conversion and overtime mistakes before payroll does. Takes two minutes per employee. It's cheap insurance against the $1,040 problem from the chart above, and it gives you a feel for what automated totals look like before you commit to anything.

How do you know when you've outgrown the template? Watch for three signs: you spend more than an hour per pay period chasing, correcting, or retyping sheets; you've found at least one math error that made it into a paycheck; or you can't say who's clocked in right now without calling someone. Any one of those means the spreadsheet is costing more than it saves, even at a price of zero.

Timesheet template rules that come from federal law

Whatever format you pick, completed timesheets are legal records, not scratch paper. Federal rules set specific retention floors: payroll records must be preserved for at least 3 years under 29 CFR 516.5, and the supplementary records behind them, including "time and earning cards or sheets," for at least 2 years under 29 CFR 516.6. In practice, keep everything at least 3 years and you'll never think about the distinction.

The format itself is your call. The timesheet template requirements that actually come from federal law are thinner than most people expect. The FLSA requires accurate records of hours worked but doesn't mandate paper, spreadsheet, or software, so a well-built template satisfies the law as long as it's accurate and retained. What trips small businesses up in wage claims isn't the format. It's gaps: missing weeks, unsigned sheets, and totals that don't survive a recalculation. If a former employee claims unpaid overtime two years from now, a complete stack of signed, correctly totaled timesheets is the whole defense.

One more habit that pays off: archive by pay period, not by employee. When a wage question comes up, it comes up as "show me the week of June 15," and a folder per period answers that in seconds. Name files consistently (2026-06-15_smith.pdf) and export spreadsheet tabs to PDF once the period is approved, so later edits can't quietly change history. Cloud storage makes the 3-year retention window a non-issue; a single drawer of unsorted paper makes it a weekend project.

The best timesheet template is the one that gets filled in honestly and totaled correctly, which is a lower bar than the download pages suggest and a higher one than most crews clear. Start with the columns above, add the four formulas, protect the cells, and put a recurring reminder on your own calendar to archive each pay period's sheets. Or skip the maintenance entirely and let a free time clock produce the records as a side effect of people simply showing up and punching in.