Time Tracking Spreadsheet: How to Build One in Excel or Google Sheets

A time tracking spreadsheet is the cheapest way to find out where your work hours go. You need Excel or Google Sheets, five columns, and two formulas. No account, no subscription, no learning curve. For a lot of freelancers and small teams, that is genuinely enough, at least for a while.

The catch is that most spreadsheet templates you find online are either too bare to be useful or so bloated with macros that they break the first time you edit them. This guide shows you the layout that holds up in practice: which columns to create, the exact formulas to paste in, how to build a weekly summary tab, and the honest signals that tell you a spreadsheet has stopped paying for itself.

The time tracking spreadsheet layout that works

Every workable time log comes down to one row per block of work. Resist the urge to make one row per day with a dozen columns. Rows are cheap, and one-row-per-task makes every later calculation easier.

Create a sheet called Log with these columns:

Two setup tips that save cleanup later:

• Make Project a dropdown. In Google Sheets: Data → Data validation → Dropdown. In Excel: Data → Data Validation → List. Typing project names by hand guarantees you end up with “Acme”, “acme” and “Acme ” as three different projects.
• Format Start and End as time. If the cells are stored as text, every formula below returns an error or, worse, a wrong number that looks right.

Time tracking spreadsheet formulas you can copy

You only need a handful. Assume Start is in column D, End in column E, and row 2 is your first entry.

Hours worked, as a decimal:

=(E2-D2)*24

Spreadsheets store times as fractions of a day, so subtracting two times gives you a fraction. Multiplying by 24 turns 2:25 of elapsed time into 2.42, which is what you want for invoicing and summing.

Shifts that cross midnight:

=MOD(E2-D2,1)*24

Plain subtraction goes negative when you start at 22:00 and finish at 1:30. MOD wraps it around and returns 3.5.

Total hours for the whole log:

=SUM(F2:F1000)

Hours for one project:

=SUMIF(B2:B1000,"Acme redesign",F2:F1000)

Billable hours only:

=SUMIFS(F2:F1000,G2:G1000,"Yes")

If you bill by the hour, add a Rate column and multiply. That, plus a clean log, covers most of what paid timesheet tools do. For the invoicing side of that workflow, see our guide to tracking billable hours.

Excel or Google Sheets?

The formulas above work identically in both. The differences that matter:

• Google Sheets wins for access. The log lives at a URL, you can add entries from your phone, and sharing with a client or teammate is one click. Version history is automatic.
• Excel wins for heavy lifting. If your log grows past tens of thousands of rows or you want pivot tables with custom groupings, Excel stays fast where Sheets starts to lag.

For a personal or small team log, pick whichever you already have open every day. The best time tracking spreadsheet is the one you actually fill in, and friction is the main reason people stop.

Add a weekly summary tab

A raw log answers “what did I do on Tuesday”. A summary tab answers the question you actually care about: “where did this week go”. Create a second sheet called Summary.

The one formula that does most of the work is SUMIFS with a date range. To total hours per project for the current week, list your project names in column A, then:

=SUMIFS(Log!F:F, Log!B:B, A2, Log!A:A, ">="&TODAY()-WEEKDAY(TODAY(),2)+1)

That sums hours for the project in A2 from Monday of the current week onward. Copy it down your project list and you have a live weekly report. Add a second version with a fixed date range when you need a report for a specific week.

Two summary views worth building:

1. Hours per project per week. This is the number you invoice from and the one that tells you a “small” client is quietly eating a third of your time.
2. Billable share. Billable hours divided by total hours. If you log honestly, this number is usually lower than you expect, and watching it weekly changes how you plan your days.

If you mainly need totals for payroll or invoices rather than analysis, our simpler guide on keeping track of work hours covers lighter options too.

When a spreadsheet is enough

A time tracking spreadsheet is a fine long term solution when:

• You work in a few long blocks per day, so logging takes a minute
• You bill a small number of clients and mostly need weekly totals
• You want full control of the data, with no vendor and no export lock-in
• You track for your own awareness, not for compliance or an audit trail

There is no rule that says you must graduate to an app. Plenty of freelancers run their whole business on one well built sheet.

Where time tracking spreadsheets break down

The weaknesses all come from the same root: a spreadsheet only knows what you remember to type into it.

• You have to remember, every time. The log is only as good as your discipline at 4pm on a busy Thursday. Most people reconstruct their day from memory hours later, and reconstructed logs drift toward guesses.
• Rounded guesses compound. “Roughly 9 to 12” written at the end of the day hides the twenty minutes of email and the two Slack detours inside it. Over a month of invoices, those guesses add up in one direction or the other.
• No idle detection. The sheet cannot tell that you left for lunch with the block still “running” in your head.
• Nothing is captured automatically. Which apps, sites and documents the hours actually went to is exactly the information a spreadsheet never has, and it is the information you need when a day felt busy but produced nothing.

Automatic trackers exist to remove that manual step: they watch which app, website or document is in front of you and build the log for you. We compare the options in our roundup of automatic time tracking software. If you are on a Mac, Chronoid does this locally on your machine: it captures apps, websites, documents and even AI coding sessions on its own, keeps all data on your Mac, and comes with a 7-day free trial followed by a one-time purchase instead of a subscription.

A practical middle path: keep your spreadsheet as the billing record, and run an automatic tracker alongside it for a couple of weeks. Comparing the two logs shows you exactly how much your manual entries drift.

Frequently Asked Questions

How do I create a time tracking spreadsheet from scratch?

Make a sheet with columns for Date, Project, Task, Start, End and Hours. Format Start and End as times, add =(E2-D2)*24 in the Hours column, and total with SUM or SUMIF. Add a dropdown for project names so entries stay consistent. That is the whole build, about ten minutes of setup.

How do I calculate hours worked in Excel?

Subtract the start time from the end time and multiply by 24 to get decimal hours: =(End-Start)*24. For shifts that cross midnight use =MOD(End-Start,1)*24. Sum the results with =SUM() for totals, or =SUMIF() to total one project or client at a time.

Does Google Sheets have a time tracking template?

Google Sheets ships a basic weekly timesheet in its template gallery, and many companies publish free templates you can copy. Most are thin wrappers around the same layout described above, so building your own takes about as long and leaves you with formulas you understand and can fix.

Why does my hours formula show a time instead of a number?

The cell inherited a time format. Spreadsheets often auto-format the result of End minus Start as a clock time, so 2.42 hours displays as 10:04. Select the Hours column and set the format to Number, then the decimal value shows correctly.

Are spreadsheets accurate for time tracking?

They are exactly as accurate as the person filling them in. The formulas never make mistakes, but entries typed from memory at the end of the day routinely miss short tasks and interruptions. If your invoices depend on precise numbers, log in real time or pair the sheet with an automatic tracker and reconcile weekly.

Start with the sheet, upgrade when it hurts

A time tracking spreadsheet is the right first tool: free, private, and flexible enough to match how you work. Build the log with one row per work block, paste in the decimal hours formula, and put a SUMIFS summary on top. You will know within two weeks whether the habit sticks.

If it does not stick, that is information too. The gap between what you log and what actually happened is the strongest argument for letting software do the logging. Keep the spreadsheet for your records, and let an automatic tracker fill it with data you did not have to remember.

Cover photo by Lukas Blazek on Unsplash