Timesheet Template: Columns, Formulas, and the Mistakes to Avoid

Pick a structure: weekly, biweekly, or monthly

Your timesheet structure should match your pay period — one timesheet per pay cycle keeps approval and payroll simple. A weekly timesheet has 7 day-rows plus a totals row, and it's the cleanest format because federal overtime is calculated per workweek (over 40 hours in a week earns 1.5× pay), so the overtime math lives entirely on one sheet.

A biweekly template timesheet covers 14 days, but it must keep the two workweeks visually separate with a subtotal after each week. Overtime is figured week by week, never across the full 14 days — 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 timesheets are the trickiest, because workweeks straddle the start and end of the period. If you pay semimonthly, you still need running weekly totals somewhere on the sheet to catch overtime correctly. Many businesses on semimonthly pay keep weekly timesheets anyway and map them to pay periods at payroll time.

The exact columns every timesheet template needs

Left to right: Date, Day, Time In, Time Out, Break (minutes or a second in/out pair), Daily Total, and Notes. At the bottom: Regular Hours, Overtime Hours, and Total Hours for the week. The header should carry the employee's name, the pay period dates, and signature lines for the employee and supervisor — those signatures matter if hours are ever disputed.

If your team takes a single unpaid lunch, one Break column with minutes (e.g., 30) is enough. If people clock out and back in for breaks, use four time columns instead: Morning In, Lunch Out, Lunch In, Evening Out. Remember the federal rule of thumb: short breaks of 5–20 minutes are paid time and shouldn't be deducted; bona fide meal breaks of 30+ minutes where the employee is fully relieved of duty can be unpaid.

Add an Overtime column only on the weekly summary line, not per day. Under the FLSA, overtime is weekly (over 40 hours), though a handful of states add daily overtime rules — confirm with your state labor department before you assume weekly-only applies to you.

The spreadsheet formulas that total hours correctly

In Excel or Google Sheets, enter times as real time values (9:00 AM, 5:30 PM), not text. The daily total formula is: =(TimeOut − TimeIn) × 24 − BreakMinutes/60, with the cell formatted as a plain number. Example: in at 8:00 AM, out at 4:45 PM, 30-minute lunch gives (16.75 − 8.00) − 0.5 = 8.25 hours.

For overnight shifts that cross midnight, the subtraction goes negative, so use: =MOD(TimeOut − TimeIn, 1) × 24 − BreakMinutes/60. 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).

If you build a timesheet xls template once with these formulas and protect the formula cells, employees can only type into the time columns — which eliminates most "the spreadsheet is broken" emails.

The 8:30 vs 8.50 decimal mistake

The most common timesheet error: 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. At $20 an hour, that's $4 a day, $20 a week, roughly $1,000 a year — per employee.

The conversion rule: divide minutes by 60. 15 minutes = 0.25, 20 minutes = 0.33, 30 minutes = 0.5, 45 minutes = 0.75. If your template uses real time values and the formulas above, the spreadsheet does this conversion for you, which is exactly why typed-in decimal hours are the riskier design.

Watch for the same trap in reverse at payroll: a payroll system expecting decimal hours will read "8.30" as 8 hours 18 minutes. Pick one convention — decimal hours everywhere — and label the column "Hours (decimal)" so nobody guesses.

Printable vs digital timesheets

Printable timesheets still make sense for tiny crews, job sites without reliable devices, and anywhere a clipboard is genuinely faster. Their weaknesses are real, though: handwriting disputes, no math checking, retyping into payroll, and the classic Friday-afternoon reconstruction where everyone "remembers" they worked exactly 8 hours every day.

A digital template timesheet in Sheets or Excel fixes the math but not the memory problem — people still fill it in after the fact. The next step up is a time clock app, where employees punch in and out in real time and the timesheet builds itself. That removes both the arithmetic errors and the end-of-week guesswork.

Whichever route you take, keep completed timesheets. The FLSA requires employers to retain records of hours worked — wage records generally for at least three years and the time records behind them for at least two — and old timesheets are your defense in any wage claim.

Frequently asked questions

Keep reading