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.

Free downloads

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.

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

Step by step

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

  1. Download and openOpen the .xlsx in Excel 2010 or newer. Files from the internet open in Protected View first, so press Enable Editing.
  2. Fill the orange cellsName, period start date and approver at the top. The hourly rate is optional: leave it blank to skip pay.
  3. 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.
  4. Type the break in minutesWrite 30 for a half-hour unpaid lunch. Leave it blank if there was no unpaid break.
  5. Leave the grey cells aloneHours, totals and pay are formulas. Typing over them breaks the sum for that row.
  6. 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

  1. Download the .xlsxGoogle Sheets reads Excel files directly, so you do not need a separate Sheets version.
  2. Import itOpen a blank spreadsheet in Google Sheets, then File, Import, Upload, and pick the file.
  3. Choose how to importPick Replace spreadsheet (or Insert new sheet(s) to add it to a workbook you already use), then Import data.
  4. Fill it inThe orange cells, formulas, time formats and drop-downs all carry over. Type times as 9:00 AM or 17:30.
  5. Reuse itFile, Make a copy for each new period, and Share it with the approver so they can check it in place.
  6. Print or send a PDFFile, Download, PDF. Set the scale to Fit to width so every column stays on the page.
Under the hood

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.
Worked example

How to fill in a timesheet

  1. Fill in the header once.Name, ID, the date the period starts, and who approves it.
  2. Log each day the same day.Start time, end time, and any unpaid break, in minutes.
  3. Use clock times, not totals.Write 9:10 AM, not "about 9". The formulas do the subtraction.
  4. Add a note for anything unusual.Client call, travel, a day off, a shift swap.
  5. 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.

Checklist

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.
Retention

How long to keep timesheets

2 years Time cards and other records used to work out wages, under the US Fair Labor Standards Act.
3 years Payroll records, under the same rules.

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.

Pay periods

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
Team builder

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.

Preview of your blank sheet 7 rows
Member Date Start Finish Break (min) Hours Project Notes
Team member 2026-11-22
Team member 2026-11-23
Team member 2026-11-24
Team member 2026-11-25
Team member 2026-11-26
Team member 2026-11-27
Team member 2026-11-28
Avoid these

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.
Signs you have outgrown it

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.
Automatic timesheets

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
Start free trial
TimoDesk monthly timesheet PDF with daily hours for every team member
Questions

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.

Still have a question? Book a call. We'll show you TimoDesk with your own setup and answer any question this list doesn't cover. Talk to our team

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.
Need help? Book a one-hour TimoDesk demo Book a meeting