Blog Productivity Time tracking template for Excel and Google Sheets
Productivity · Nov 16, 2026
Time tracking template for Excel and Google Sheets
Build a free time tracking template in Excel or Google Sheets: columns, working formulas for hours, breaks and overnight shifts, and when to use an app.
How do you build a time tracking template in Excel or Google Sheets?
Use six columns, Date, Start, End, Break, Hours and Project, then one formula for hours. Copy the layout into row 1 and fill rows below it. The formulas below work in both programs.
| A: Date | B: Start | C: End | D: Break (min) | E: Hours | F: Project |
|---|---|---|---|---|---|
| 2026-11-02 | 09:00 | 17:30 | 30 | 8.0 | Client A |
| 2026-11-03 | 08:45 | 17:30 | 30 | 8.25 | Client B |
Which formulas do you need?
Put these in column E, starting at row 2. Format Start and End as time, and Hours as a number.
| Goal | Formula |
|---|---|
| Hours worked, same day | =(C2-B2)*24-D2/60 |
| Shift that crosses midnight | =MOD(C2-B2,1)*24-D2/60 |
| Total for the week | =SUM(E2:E6) |
| Total per project | =SUMIF(F:F,"Client A",E:E) |
Both programs store a time as a fraction of a day. Multiplying by 24 turns it into hours, and dividing the break by 60 turns minutes into hours. Some Excel language versions use a semicolon instead of a comma between arguments.
What does a worked example look like?
Start 08:45, end 17:30, 30 minutes break. The span is 8 hours 45 minutes, or 8.75 hours. Minus 0.5 hours gives 8.25 hours. Over five such days the total is 41.25 hours.
When does a spreadsheet work well?
- A handful of projects and a few entries a day
- A one-off record for a client or a manager
- Zero cost, if you already have the software
When does a spreadsheet break down?
You have to remember to write down every start and end. Forgotten entries are the usual reason spreadsheet hours are wrong, and the gaps are hard to see later. If you work in many apps and tabs, an automatic tracker records the time for you. See time tracking spreadsheet vs app.
Can you combine both?
Yes. TimeUno records time automatically on Mac and Windows and in Chrome, Firefox and Edge. It exports a CSV timesheet, which you can paste into the template above, and a PDF. It has no invoicing, no accounting integrations and no free tier. There is a 14-day trial, and Individual is $9.99 a month, or $8.33 billed yearly, as of November 2026. Source: pricing. For the arithmetic behind the sheet, read how to calculate hours worked on a time card.
FAQ
Is there a free time tracking template for Excel?
Yes. The layout and formulas above cost nothing and work in Excel and Google Sheets.
How do I total hours per project?
Use =SUMIF(F:F,"Client A",E:E), with your project name in the formula.
Why is my result wrong after midnight?
Plain subtraction goes negative. Use =MOD(C2-B2,1)*24-D2/60.
Can I import TimeUno data into the sheet?
Yes. Export a CSV from TimeUno and paste it into the template.