Which format do you want?
Two things come out of this page, and they suit different jobs.
- Print / PDF produces a clean sheet with dated rows, blank fields for employee, employer, pay period and rate, and signature lines at the bottom. Use it where someone has to sign — site work, agency placements, anywhere a paper record is expected. Choosing "Save as PDF" in the print dialogue gives you a file to email instead.
- Download CSV gives you a spreadsheet with the dates already filled in, ready to open in Excel, Numbers or Google Sheets and to have formulas added.
Both are generated in your browser from the current date, so the dates are always right and there is nothing to sign up for.
Adding formulas to the CSV
The downloaded CSV has an Hours column left blank on purpose. In a spreadsheet, times are fractions of a day, so subtracting them and multiplying by 24 gives decimal hours. With start in C2, end in D2 and break minutes in G2:
| Goal | Formula |
|---|
| Hours for one shift | =(D2-C2)*24 |
| Hours across midnight | =MOD(D2-C2,1)*24 |
| Minus an unpaid break | =MOD(D2-C2,1)*24-G2/60 |
| Week total | =SUM(H2:H8) |
| Overtime above 40 hours | =MAX(0,H9-40) |
| Gross pay at $/hr in B12 | =(H9-MAX(0,H9-40))*B12+MAX(0,H9-40)*B12*1.5 |
MOD(end-start,1) is the spreadsheet version of the add-1,440-minutes trick: it keeps overnight shifts positive instead of returning an error or a negative number.
What a timesheet should record
If you are designing your own, these are the fields that tend to matter when a sheet is questioned later:
- The date — not just the day name. "Tuesday" is ambiguous three weeks later.
- Start and end times rather than a total. A bare "8 hours" cannot be checked against anything.
- Unpaid breaks, separately from worked time. This is the field most disputes turn on.
- Daily hours and a period total, so daily and weekly overtime rules can both be applied.
- Notes — the project, client, job number or the reason a day was short.
- Signatures where approval is part of the process.
In the United States, employers covered by the FLSA must keep time records for non-exempt employees for at least two years. Your own copy is worth keeping just as long — a printed sheet or an exported CSV is far easier to produce later than a screenshot.
Or skip the sheet entirely
A blank template still leaves you adding up minutes by hand. The online timesheet calculator does the same job with the arithmetic already done: type your times, get hours, breaks, overtime and pay, then print the same signed-off sheet or export a CSV. It saves in your browser, so the week is still there tomorrow, and nothing is uploaded anywhere.
Frequently asked questions
Are these templates free?
Yes, completely — no sign-up, no email, no watermark. They are generated in your browser when you click.
What file format is the download?
CSV, which opens directly in Microsoft Excel, Apple Numbers, Google Sheets and LibreOffice. It is plain text, so it will still open in a decade.
Can I get a PDF?
Yes. Choose Print / PDF and then pick “Save as PDF” as the destination in your browser's print dialogue.
Do the templates calculate hours for me?
No — printed and CSV sheets are blank by design so you can fill them in by hand or add your own formulas. If you want the totals computed automatically, use the online timesheet calculator instead.
Which dates do the templates use?
The current period: this week for the weekly sheet, this fortnight for the biweekly, and the current calendar month for the monthly. Change the week-start option if your pay week runs Sunday to Saturday.
How long should I keep my timesheets?
Employers covered by the US FLSA must keep time records for at least two years, and other jurisdictions set similar or longer periods. Keeping your own copy for the same length of time is sensible if pay is ever disputed.
Other calculators
⏱
Weekly timesheet calculator
A full week at a time, with breaks, overtime, saving, export and printing.
🕘
Time card calculator
One day, punched in and out up to three times, with a break deduction.
↔️
Hours between two times
How long is 9:15 to 17:40? Decimal hours, hours and minutes, total minutes.
💵
Overtime pay calculator
Split hours into regular, overtime and double time and price each band.
🔢
Minutes to decimal chart
The 0–59 minute conversion table payroll expects, plus a live converter.