Timesheet template for Excel and Google Sheets

A free timesheet as an Excel file, with a weekly sheet and a monthly sheet. Enter the start time, the end time and an unpaid break, and it works out the hours worked, counts shifts that pass midnight, and totals the week. It opens in Google Sheets too, and there is no sign-up.

Start free

Last reviewed November 1, 2026. The file is a plain download: nothing you type in it comes back to us.

Get the template

Download the Excel timesheet (.xlsx)Printable sheets and CSV

Week: seven days from the Monday you enter, with start, end, unpaid break, hours worked and notes.
Month: up to 31 days from the first day you enter. Days outside the month stay blank.
Yellow cells are for you. Dates, days, hours worked, the total and the amount at your hourly rate calculate themselves.
The first row holds an example, 9:00 to 17:30 with a 30 minute break. Replace it with your own times.

Use it in Google Sheets

Open Google Sheets. Start a blank spreadsheet, or open Google Drive.
Import the file. Choose File, then Import, then Upload, and pick the .xlsx you downloaded. Or upload it to Drive and open it with Google Sheets.
Check the first rows. Dates, days and hours worked should fill in. Then enter your times.

The formulas use only functions that both Excel and Google Sheets have: IF, OR, MOD, ROUND, SUM, MONTH and TEXT.

The formulas, line by line

Hours worked on a row is =IF(OR(C9="",D9=""),"",ROUND((MOD(D9-C9,1)-E9/1440)*24,2)), with the start in C, the end in D and the unpaid break in minutes in E.

D9-C9 is the time between start and end as a fraction of a day.
MOD(...,1) keeps it positive when the shift ends after midnight, so 22:00 to 06:00 counts as 8 hours, not minus 16.
E9/1440 turns the break from minutes into a fraction of a day (there are 1,440 minutes in a day).
*24 turns the fraction of a day into hours, and ROUND(...,2) keeps two decimals.
The total is =SUM(F9:F15) on the Week sheet, and the amount is the total multiplied by the hourly rate you enter, rounded to the cent.

Three shifts and the hours the worksheet shows for each.
Shift	Hours worked
9:00 to 17:30, 30 minute break	8.00
22:00 to 06:00, 30 minute break	7.50
9:00 to 12:45, no break	3.75

Breaks, overnight shifts and overtime

Enter breaks that you do not get paid for in minutes, and leave the cell empty if there was none. Enter times as clock times such as 9:00 and 17:30; a shift that ends the next morning is counted correctly.

The sheet does not work out overtime. Whether overtime is owed depends on the job, the place and the law, not on how the hours are tracked: see the US Department of Labor's overtime guidance.

Rounding hours

The sheet shows hours as decimals to two places, so 7 hours 45 minutes is 7.75. If you bill or pay in increments, round each entry to the increment first: a 6-minute step is 0.1 hour and a 15-minute step is 0.25 hour. The minutes to decimal converter has the full chart.

When a spreadsheet stops being enough

More than one person: you collect files, and nobody can check one version.
You need to approve or lock a week, or see who has not sent theirs.
You invoice a client from the hours, and retype them into an invoice.
You want one place for hours, rates and what each project cost.

Honest Day tracks the same entries in a timer, a week grid and a calendar, and invoices from them. The free plan covers up to 5 members with unlimited projects, time entries and invoices. To bring a spreadsheet in, use the CSV layout on the timesheet templates page; this workbook is for your own use.

Questions

How do I create a timesheet in Excel or Google Sheets?

Put the date, start time, end time and unpaid break in columns, then add a column for hours worked with the formula =IF(OR(C9="",D9=""),"",ROUND((MOD(D9-C9,1)-E9/1440)*24,2)) and a total with =SUM() under it. Or download the file on this page, which has that already built for a week and a month.

How do I calculate hours worked with a lunch break in Excel?

Subtract the start from the end, subtract the break as minutes divided by 1,440, then multiply by 24: =(D9-C9-E9/1440)*24. Wrap it in MOD(D9-C9,1) if a shift can pass midnight.

How do I calculate hours past midnight in Excel?

Use MOD to wrap the difference: =MOD(D9-C9,1)*24. For 22:00 to 06:00 that gives 8 hours. The template does this for every row.

How do I write 7 hours 45 minutes on a timesheet?

As 7:45 if the sheet takes clock durations, or as 7.75 in decimal hours. This template shows decimals, so 7:45 appears as 7.75. The minutes to decimal converter converts both ways.

Can I use the Excel timesheet in Google Sheets?

Yes. In Google Sheets choose File, then Import, then Upload and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. The formulas use only functions both programs have.

Is the timesheet free, and do I need to sign up?

It is free and needs no sign-up. The file is a plain download. The site records only that the download was used, never what you type in the file.

Is there a monthly version?

Yes. The Month sheet in the same workbook has up to 31 rows from the first day of the month you enter, with the same hours and total formulas.

Track time without the spreadsheet.

Honest Day has a timer, a week grid and a calendar, and builds invoices from the hours. Free for up to 5 members, no credit card.

Start free See the whole product