Free timesheet templates
Download a free weekly, biweekly, monthly, daily or project timesheet template for Excel and Google Sheets, with the formulas already in. Or print a blank PDF.
Timesheet templates for Excel, Google Sheets and print
Every spreadsheet adds up its own hours, handles lunch breaks and overnight shifts, and has room for a name, the period and an approver's signature. No sign-up, no macros.
-
7 days
Weekly timesheet template
One person, one week. The most common employee timesheet, and short enough to fill in accurately every day.
- Dates fill in from the week start
- Break minutes taken off each day
- Weekly total and optional gross pay
-
14 days
Biweekly timesheet template
For teams paid every two weeks. Each week gets its own subtotal, so a long first week is not hidden by a short second one.
- Week 1 and week 2 subtotals
- Period total and optional gross pay
- Overnight shifts counted correctly
-
28 to 31 days
Monthly timesheet template
A full month on one page. Dates stop at the end of the period, so February has 28 rows and October has 31.
- Works from any start day
- Days worked counted for you
- Monthly total in decimal and h:mm
-
1 day, whole team
Daily timesheet with lunch break
A sign-in sheet for one shift. Each person punches in, out for lunch, back in and out, and lunch is taken off automatically.
- Lunch minutes worked out for you
- Up to 15 people per sheet
- Signature column for each row
-
Clients and billing
Project timesheet template
Log hours per client, project and task. Mark each row billable or not, and the amount to invoice adds up on its own.
- Billable and non-billable hours
- Row rate or one default rate
- Hours and amount per client
-
Need every name and date filled in?
Build a team timesheet in your browser: pick weekly, biweekly or monthly, paste your team, and download a CSV with one row per person per day. Or print one sheet per member.
Open the team CSV builder
Light orange cells: you fill these in Grey cells: formulas, they calculate on their own Works in Excel 2010 or newer, Google Sheets, LibreOffice and Numbers
How to use the timesheet template in Excel and Google Sheets
One file works in both. Each workbook also has a "How to use" tab with these steps.
In Microsoft Excel
- Download and openOpen the .xlsx in Excel 2010 or newer. Files from the internet open in Protected View first, so press Enable Editing.
- Fill the orange cellsName, period start date and approver at the top. The hourly rate is optional: leave it blank to skip pay.
- Type real timesUse a colon: 9:00 AM, 5:30 PM or 17:30. A dot (9.30) is read as a number, not a time.
- Type the break in minutesWrite 30 for a half-hour unpaid lunch. Leave it blank if there was no unpaid break.
- Leave the grey cells aloneHours, totals and pay are formulas. Typing over them breaks the sum for that row.
- Save a copy each periodFile, Save As, with the date in the name, for example timesheet-2026-11-02.xlsx. Then print with Ctrl+P or File, Export, PDF.
In Google Sheets
- Download the .xlsxGoogle Sheets reads Excel files directly, so you do not need a separate Sheets version.
- Import itOpen a blank spreadsheet in Google Sheets, then File, Import, Upload, and pick the file.
- Choose how to importPick Replace spreadsheet (or Insert new sheet(s) to add it to a workbook you already use), then Import data.
- Fill it inThe orange cells, formulas, time formats and drop-downs all carry over. Type times as 9:00 AM or 17:30.
- Reuse itFile, Make a copy for each new period, and Share it with the approver so they can check it in place.
- Print or send a PDFFile, Download, PDF. Set the scale to Fit to width so every column stays on the page.
The formulas inside each template
Spreadsheets store a time as a fraction of a day: 6:00 AM is 0.25. Subtract two times, multiply by 24 and you have hours. Here is every formula, with the cell references from the weekly sheet, so you can check them or copy them into your own.
| Column | Formula | What it does |
|---|---|---|
| Hours (decimal) | =IF(OR(C9="",D9=""),"",ROUND(MOD(D9-C9,1)*24-IF(ISNUMBER(E9),E9,0)/60,2)) |
End minus start, in hours, minus the break. MOD(...,1) makes a shift past midnight count forward. Blank until both times are in. |
| Hours (h:mm) | =IF(F9="","",F9/24) |
The same hours shown as a clock, with the [h]:mm format so totals over 24 hours still show correctly. |
| Date | =IF(F4="","",F4+0) |
Each row adds one day to the start date. On the monthly sheet, rows past the end of the period stay empty. |
| Total hours | =SUM(F9:F15) |
Adds the decimal hours. On the biweekly sheet it adds the two weekly subtotals. |
| Gross pay | =IF(ISNUMBER(F5),ROUND(F16*F5,2),"") |
Total hours times the hourly rate, rounded to cents. Blank when there is no rate. |
| Lunch (min) | =IF(OR(D8="",E8=""),"",ROUND(MOD(E8-D8,1)*1440,0)) |
Daily sheet only: lunch in minus lunch out, in minutes. 1,440 is the number of minutes in a day. |
| Billable hours | =SUMIF(I8:I27,"Y",H8:H27) |
Project sheet only: adds the hours on rows marked Y. Amount per row is hours times the row rate or the default rate. |
How to fill in a timesheet
- Fill in the header once.Name, ID, the date the period starts, and who approves it.
- Log each day the same day.Start time, end time, and any unpaid break, in minutes.
- Use clock times, not totals.Write 9:10 AM, not "about 9". The formulas do the subtraction.
- Add a note for anything unusual.Client call, travel, a day off, a shift swap.
- Check the totals, then sign.Both of you sign and date it before it goes to payroll or a client.
Need to turn a clock total into decimals by hand? The decimal hours calculator has a full minutes to decimal table, and the work hours calculator adds up a week without a spreadsheet.
One week, $25 an hour
| Day | Start | End | Break | Worked | Decimal | h:mm |
|---|---|---|---|---|---|---|
| Mon | 9:00 AM | 5:30 PM | 30 | 8:30 - 0:30 | 8.00 | 8:00 |
| Tue | 8:45 AM | 5:15 PM | 30 | 8:30 - 0:30 | 8.00 | 8:00 |
| Wed | 9:10 AM | 6:00 PM | 45 | 8:50 - 0:45 | 8.08 | 8:05 |
| Thu | 9:00 AM | 1:00 PM | - | 4:00 | 4.00 | 4:00 |
| Fri | 10:00 PM | 6:30 AM | 30 | 8:30 - 0:30 (overnight) | 8.00 | 8:00 |
| Total hours | 36.08 | 36:05 | ||||
Gross pay = 36.08 x $25 = $902.00. Wednesday is 8.08, not 8.05: the extra 5 minutes are 5 / 60 = 0.083 of an hour. Friday is a night shift, and still one row.
What an employee timesheet must include
There is no official timesheet form in the United States. The Department of Labor's recordkeeping fact sheet says the law requires no particular form, and any timekeeping method is fine as long as it is complete and accurate. For workers paid by the hour, the records it lists include the hours worked each day, the total for each workweek, and when the workweek begins. A useful timesheet covers these:
- Who Full name and an employee ID or role, so the sheet cannot be mixed up with someone else's.
- When the week starts The day and time the workweek begins. It can be any day, and weekly totals follow it, not the calendar week.
- Each day's hours Date, start, end and unpaid breaks, plus the hours worked that day.
- Weekly totals Total hours for each workweek, even on a biweekly or monthly sheet.
- Pay basis The hourly rate or other basis of pay, if the timesheet feeds payroll or an invoice.
- Sign-off Employee signature, approver signature and the dates they signed.
How long to keep timesheets
Both figures come from the US Department of Labor fact sheet #21. They are federal minimums. Some states, other countries and tax rules can ask for longer, so check the rule where you employ people. This page is general information, not legal advice.
In practice, keep the signed copy, not just the spreadsheet: save each approved timesheet as a PDF with the period in the file name, in one folder per year.
Weekly, biweekly, semimonthly or monthly?
Pick the timesheet that matches how often you pay or invoice. Shorter periods are easier to fill in accurately.
| Period | Covers | Per year | Usually for | Template to use |
|---|---|---|---|---|
| Weekly | 7 days | 52 | Hourly staff, contractors, anyone who bills weekly | Weekly |
| Biweekly | 14 days | 26 | Payroll every other week, on the same weekday | Biweekly |
| Semimonthly | 15 or 16 days | 24 | Pay on the 15th and the last day of the month | Monthly: start on the 1st or 16th, stop at the period end |
| Monthly | 28 to 31 days | 12 | Salaried staff, freelancers billing monthly, client reports | Monthly |
| Daily | 1 day | n/a | Shift work, sites and crews signing in together | Daily with lunch break |
Build a team timesheet CSV
Every name repeated for every date, with no typos. Download it as a CSV for Excel or Google Sheets, or print one blank sheet per member. It is built in your browser, so the names you type are not uploaded.
Tip: Your period, start date and names are kept in this browser, so a refresh does not lose them.
| Member | Date | Start | Finish | Break (min) | Hours | Project | Notes |
|---|---|---|---|---|---|---|---|
| Team member | 2026-11-10 | ||||||
| Team member | 2026-11-11 | ||||||
| Team member | 2026-11-12 | ||||||
| Team member | 2026-11-13 | ||||||
| Team member | 2026-11-14 | ||||||
| Team member | 2026-11-15 | ||||||
| Team member | 2026-11-16 |
Showing the first 10 rows. The download contains every row.
Common timesheet mistakes
Most wrong timesheets are not dishonest. They are filled in late, in the wrong format.
- Writing 7.30 for seven and a half hours Seven and a half hours is 7:30 on a clock and 7.50 in decimal. Payroll multiplies decimals, so 7.30 underpays by 12 minutes.
- Filling it in on Friday A week of start times rebuilt from memory is a guess. Fill in each day before you log off, even if it takes ten seconds.
- Typing times as words "9am" or "9.00" is text or a number to a spreadsheet. Type 9:00 AM so the formulas can read it.
- Taking off the wrong break Only unpaid breaks come off. Short paid rest breaks stay in the hours worked. Check which breaks are paid where you work.
- Splitting a night shift A shift from 10 PM to 6 AM is one row, not two. The templates count forward past midnight on their own.
- Changing it after approval Once both people sign, fix mistakes with a new, signed correction instead of editing the old numbers.
When a spreadsheet timesheet stops working
A template is the right tool for a few people who fill it in every day. These are the signs it no longer is.
- People forget to fill it in You spend the last day of every month chasing missing sheets.
- Totals do not match Someone typed over a formula, or two copies of the same sheet disagree.
- Clients want proof A client asks what the hours were spent on, and a typed number is all you have.
- The team is remote Signing and collecting paper or files across time zones takes longer than the work it records.
The monthly timesheet PDF that builds itself
TimoDesk records time while the work happens, from a desktop timer on Windows, macOS and Linux. At the end of the month the timesheet is already there for every member, and you download it as a PDF for payroll or a client: one page for the team, or one page per member. See how timesheets and exports work, and how manual time is approved and kept apart from tracked time.
- Monthly timesheets generated per member, with a PDF export
- Members can download their own timesheet without asking
- Time reports by member and project, with CSV export
- Screenshots at an interval you choose as proof of work, and nothing captured when the timer is off
- $1 per user per month, every feature included, 15-day free trial
About timesheet templates
Excel and Google Sheets, lunch breaks, night shifts, and how long to keep the records.
Is this timesheet template really free?
Yes. Every template downloads without a sign-up or an email address. The files are plain .xlsx, .csv and .pdf with no macros, so you can edit, copy and share them as you like.
Does the Excel timesheet template calculate hours automatically?
Yes. Type a start time, an end time and the unpaid break in minutes, and the Hours column fills in as decimal hours (7.50) and as hours and minutes (7:30). Daily, weekly and period totals add up on their own, and pay appears when you enter an hourly rate.
How do I use the timesheet template in Google Sheets?
Download the .xlsx file. In Google Sheets, open a blank spreadsheet, choose File, then Import, then Upload, and pick the file. Choose Replace spreadsheet and import. The formulas, formatting and drop-downs carry over.
Is there a timesheet template with a lunch break?
Yes, two ways. The weekly, biweekly and monthly templates have a Break (min) column that is taken off each day. The daily timesheet has Lunch out and Lunch in columns for the whole team, and works out the lunch minutes for you.
Does the template work for night shifts that end after midnight?
Yes. The hours formula uses MOD, so a shift from 10:00 PM to 6:00 AM counts as 8 hours instead of a negative number. You do not need a second row for the next day.
Which is better, a weekly or biweekly timesheet?
Match the timesheet to your pay period. A weekly timesheet covers 7 days and a biweekly one covers 14, with a subtotal for each week. If you can choose, weekly is easier to fill in accurately, because people remember one week better than two.
How do I convert minutes to decimal hours on a timesheet?
Divide the minutes by 60. 15 minutes is 0.25, 30 minutes is 0.5 and 45 minutes is 0.75, so 7 hours 45 minutes is 7.75 hours. The templates do this for you in the Hours (decimal) column.
How long should I keep employee timesheets?
In the United States, the Department of Labor says time cards and other records used to work out wages should be kept for two years, and payroll records for at least three. Other countries and some states set different periods, so check the rule where you are.
Can I print a blank timesheet?
Yes. Each template has a printable PDF version with every column, a total row and signature lines. The Excel files are also set to fit one page wide, so Ctrl+P prints a clean sheet.
Is there a timesheet that fills itself out?
Yes. TimoDesk builds monthly timesheets from hours tracked in its desktop app, and you can download them as a PDF for payroll or clients. It costs $1 per user per month, with every feature included.
Start tracking time this week
Create your organization and invite your team today. Tracked time shows on the dashboard the same day, and the first full-day reports are ready the next day. $1 per user per month, with every feature included.
- $1 per user / month
- 15-day free trial, no card
- Stop anytime. No contract.