Time Tracking in Excel: Free Timesheet Template

Looking for a way to track hours in Excel? You get three things here: the template, the formulas you actually need, and the honest fine print about when a spreadsheet starts costing more than it saves.

First, the download, no email address required: free timesheet template (CSV, opens straight in Excel, Google Sheets and Numbers).

What Is a Timesheet?

A timesheet is the record in which someone logs, per day, how much time went into which work. At minimum it holds five things: date, client or project, description, number of hours, and whether those hours are billable. A weekly timesheet extends that to a full week, usually Monday through Sunday, submitted on Friday or first thing Monday.

What a timesheet is for depends on who reads it: the employee accounts for their time, the project manager watches the budget, and finance turns it into an invoice. That last one is why a timesheet has to be accurate and not merely complete. An hour logged against the wrong project ends up on the wrong invoice.

The Template: Which Columns and Why

The template has nine columns. That isn't arbitrary: each one exists because you need it later:

One tab for everyone, not one per person. The moment each employee gets their own tab with slightly different columns, totalling across the team becomes manual labour.

Recording Hours: Decimal or as Time?

This is the choice most Excel timesheets break on, so make it deliberately.

Decimal (3.5) is simplest. Half an hour is 0.5, a quarter is 0.25. It's an ordinary number, so summing it and multiplying by a rate just works. The template uses this notation.

Time notation (3:30) looks more natural but calculates differently. Excel stores time as a fraction of a day: 3:30 is internally 0.1458. That adds up fine, but the total resets to zero past 24 hours unless you give the cell the number format [h]:mm (with the square brackets). To convert to decimal, multiply by 24:

=A2*24

Pick one and stick to it. A timesheet where one person writes 7.5 and another writes 7:30 adds up to nonsense.

The Formulas You Need

Six formulas cover just about everything you'd want to know from a timesheet. They assume the template's columns: hours in H, billable in I, project in D.

Total hours

=SUM(H2:H49)

Billable hours only

=SUMIF(I2:I49,"y",H2:H49)

SUMIF adds up column H, but only for rows with a y in column I.

Hours on one project

=SUMIFS(H2:H49,D2:D49,"Website 2026")

For billable hours on that project, add a second condition:

=SUMIFS(H2:H49,D2:D49,"Website 2026",I2:I49,"y")

Utilization as a percentage

=SUMIF(I2:I49,"y",H2:H49)/SUM(H2:H49)

Format that cell as a percentage. This is the number that matters most commercially: what share of worked time is billable. What counts as healthy and how to move it is covered in increase billable utilization.

Rounding to quarter-hours

=ROUND(H2*4,0)/4

Useful if you bill in quarter-hour increments and would rather not put 2.37 hours on an invoice.

Amount to invoice

Add a Rate column (say column J) and calculate what's billable per row. Internal hours drop out on their own, because they're marked n:

=IF(I2="y",H2*J2,0)

If everyone works at the same rate, you can do it in one go for the whole sheet:

=SUMIF(I2:I49,"y",H2:H49)*90

Working in a Dutch Excel? The function names become SOM, SOM.ALS, SOMMEN.ALS, AFRONDEN and ALS, and the argument separator is a semicolon instead of a comma.

Example: One Filled-In Week

Here's what an ordinary week looks like at a rate of €90:

That's 33.5 hours, of which 31.0 billable, a utilization of 92.5%. A good week. The point of that right-hand column: without the y/n you won't know at month-end whether you hit 92.5% or 68%. Across five people, at 1,700 workable hours each per year and a €90 rate, that difference is more than €185,000 in revenue a year. One column left blank costs you the visibility on it.

Where the Spreadsheet Gives Out

The template above works. Up to a point, and that point arrives sooner than most agencies expect. Here's what goes wrong:

1. Hours that never get logged. Excel doesn't remind anyone about an empty Tuesday. Whoever reconstructs their week on Friday tends to forget exactly the most billable part: the small jobs in between. For a team of five billing €90 an hour, one forgotten quarter-hour per person per day already adds up to more than €25,000 a year in evaporated revenue.

2. Broken formulas and version chaos. Everyone knows that file: "Timesheet_week28_FINAL_v3(1).xlsx". Formulas that break when someone inserts a row, per-employee tabs that are each structured just a little differently, and an office manager who loses a full day every month copy-pasting everything into the invoicing process. Every manual handoff is a chance for errors, and those errors end up on a client's invoice.

3. No real-time picture. The most important question a project manager has is how many hours have gone into this project so far? Excel can only answer that after every timesheet has been submitted and merged. By then, the answer is a week old by definition. Which means you spot budget overruns when it's already too late.

4. No connection to anything else. A timesheet isn't a final destination: hours need to flow into an invoice, a project budget, a resource plan and a utilization report. In Excel, every one of those steps means retyping, and every step is another chance for a gap between what was logged and what was billed.

5. Approval doesn't exist. Who signs off on hours before they hit the invoice? In Excel: nobody, or someone clicking through every single tab. An approval workflow in which a project manager approves or rejects each week is practically impossible to organize in a spreadsheet.

When Is Excel Actually Enough?

Let's be fair: for a freelancer or a duo without project budgets, Excel is fine, and the template above will take you a long way. The tipping point typically comes between 5 and 10 employees, or sooner if any of these apply:

• you bill on a time-and-materials basis and can't afford to miss hours;
• you run fixed-price projects and need to keep budgets in check;
• more than one person needs access to the same numbers;
• monthly invoicing takes more than half a day.

What a Time Tracking System Does Differently

Modern time tracking software tackles exactly the leaks above: a weekly timesheet you fill in within seconds (on your phone, too), automatic reminders for incomplete weeks, real-time project counters with budget alerts, and approved hours that land on the draft invoice without retyping. The utilization you just calculated with a formula sits on the dashboard permanently.

For agencies switching from Excel, the payoff is usually twofold: less admin and more billed hours. Price doesn't have to be the obstacle: from around €20 per user per month, less than a single billable quarter-hour, you get time tracking, projects and invoicing in one system.

Frequently Asked Questions

Is the template really free? Yes. It's a CSV file that opens directly in Excel, Google Sheets or Numbers. No email address, no account.

Why a CSV instead of an .xlsx file? CSV opens in every spreadsheet program and contains no macros, so it is safe to download and easy to adapt. Save it as .xlsx after opening if you want to keep formulas and formatting.

How do I total billable hours in Excel? With SUMIF: =SUMIF(I2:I49,"y",H2:H49) adds up the hours column for every row with a y in the billable column. Divide that by =SUM(H2:H49) and you have your utilization percentage.

How do I stop my hours total from resetting after 24 hours? That happens with time notation (7:30), because Excel stores time as a fraction of a day and starts over after one. Give the total cell the number format [h]:mm, with the square brackets, or use decimal hours (7.5), as the template does.

Can I bring my Excel timesheet history into a time tracking system? With Horixa, yes: upload your timesheet as an Excel or CSV file (employee, date and hours columns are enough; there is a sample file) and the hours land on the right projects. Rows that already exist are skipped, so uploading twice does no harm. Clients, projects, leave and invoices can come over the same way, or use the REST API. Switching from another software package can even happen automatically; see the migration checklist.

At what team size does software pay for itself? The rule of thumb: as soon as one missed billable hour per week costs more than the license. At a rate of €90, you hit that point at just one lost hour per employee per month.

---

Done with copy-pasting? Try Horixa free for 14 days. Weekly timesheets, budget tracking and invoicing in one, including import of your existing data.