Excel Templates for Time Tracking: Best Free Options

How-to basics · Updated November 22, 2026

Yes, you can track time in Excel using built-in templates—Microsoft 365 includes a free Time Card template and a Weekly time sheet—and you can also build a simple tracker yourself with a few formulas. For most people, a pre-made Excel template is the fastest way to log hours, calculate totals, and export data for payroll or invoicing without buying specialized software.

Why Use Excel for Time Tracking

Excel is a middle ground between paper timesheets and full-featured time-tracking apps. It works offline, stores data on your own computer (or OneDrive), and costs nothing if you already have Microsoft 365. You can customize columns, add formulas, and create pivot tables to analyze where your hours go. For freelancers, small teams, or anyone who needs a simple weekly log, Excel is often enough—no subscription, no learning curve, and no internet required.

Built-In Templates in Microsoft 365

Microsoft 365 (and Excel 2016 and later) includes several time-tracking templates that you can open directly from the app. To find them:

  1. Open Excel and click File > New.
  2. Type “time” in the search box.
  3. Look for Time Card, Weekly time sheet, Monthly time sheet, or Project time tracker.

The Time Card template is a classic: it has columns for date, start time, end time, break, and total hours, with a daily total row and a weekly total. The Weekly time sheet adds a rate column and calculates gross pay. These templates are pre-formatted with formulas, so you only need to type your hours. On a Mac, the steps are the same—File > New from Template—and the templates are identical.

How to Build a Simple Time Tracker from Scratch

If you prefer a custom tracker, you can create one in under a minute. Here’s a basic layout that works for most people:

  • Column A: Date
  • Column B: Start time (e.g., 9:00 AM)
  • Column C: End time (e.g., 5:00 PM)
  • Column D: Break (in hours, e.g., 0.5)
  • Column E: Total hours

With dates in A2:A10, start times in B2:B10, end times in C2:C10, and breaks in D2:D10, enter this formula in E2 and drag down:

=(C2-B2)*24-D2

This subtracts the start time from the end time, multiplies by 24 to convert the decimal day into hours, and subtracts the break. For example, if B2 is 9:00 AM and C2 is 5:00 PM, and D2 is 0.5, the result is 7.5 hours. To get a weekly total, use =SUM(E2:E10) in E11. On a Mac, the formula and steps are exactly the same.

Key Formulas for Time Calculations

Time in Excel is stored as a fraction of a day (1 hour = 1/24). That’s why you multiply by 24 to get decimal hours. If you want to display total hours as “7:30” instead of 7.5, format the cell as [h]:mm (right-click > Format Cells > Custom). For payroll, you usually want decimal hours, so the *24 trick is the standard.

If you need to calculate overtime, you can use an IF formula. With total hours in E2 and the regular threshold (e.g., 40) in a cell named Threshold, use:

=IF(E2>Threshold, E2-Threshold, 0)

This returns the overtime hours. For a worked example: if E2 is 45 and Threshold is 40, the result is 5.

Choosing the Right Template for Your Needs

Before you download a template, think about what you actually need to track. Common variations include:

  • Simple weekly log – just date, start, end, total.
  • Project-based tracker – adds a column for project or client name, so you can sum hours per project.
  • Payroll timesheet – includes hourly rate, overtime, and gross pay.
  • Monthly overview – a single sheet with all days of the month, useful for salaried employees.

If you work on multiple projects, the built-in Project time tracker template is a good start—it has columns for project, task, and hours per day. You can then use a PivotTable to summarize hours by project.

Common Problems and How to Fix Them

One frequent issue is that time entries like “9:00” are not recognized as time if you type them as text. Always enter times with a colon (e.g., 9:00 AM) or use the time format. Another problem is that totals appear as 0:00 or 0.0 when the formula is wrong. Check that your cells are formatted as numbers (for decimal hours) or as time (for h:mm).

If you copy a template from the internet and the formulas don’t work, it’s often because the cell references are broken or the template uses a different date system. A quick fix is to recreate the formula manually using the layout described above.

Excel vs. Dedicated Time Tracking Software

Excel is flexible and free, but it has limitations. It doesn’t have a timer that runs in the background, it can’t automatically capture app usage, and it’s not ideal for large teams because multiple users can’t edit the same sheet in real time (unless you use Excel for the web with co-authoring). Dedicated tools like Toggl, Harvest, or Clockify offer one-click timers, mobile apps, and integrations with invoicing software. However, those tools often have monthly fees or a learning curve. For a solo freelancer or a small team that just needs to log hours at the end of the day, Excel is often sufficient.

Costs and Safety of Using Excel Templates

Excel templates themselves are free—either built into Excel or available from Microsoft’s template gallery. If you don’t have Excel, you can use the free Excel for the web (with a Microsoft account) or Google Sheets, which has similar templates. There’s no financial risk in using Excel for time tracking, but be careful with sensitive data: if you store timesheets on a shared drive, protect the sheet with a password (Review > Protect Sheet) to prevent accidental edits. Also, always keep a backup copy of your workbook, especially if you use macros—macros cannot be undone with Ctrl+Z, so save a copy before running any VBA.

Frequently Asked Questions

Can I track time automatically in Excel?

No, Excel doesn’t have a built-in timer that records the current time automatically. You can use the NOW() function to insert the current date and time, but you’d still need to press a button or type it manually. For automatic tracking, you’d need a VBA macro or a third-party add-in.

How do I calculate total hours across multiple days?

Use the SUM function on the column that contains your daily totals. For example, if your daily hours are in E2:E10, use =SUM(E2:E10). If you’re using the h:mm format, the result might display as a time value, so format the total cell as [h]:mm to show hours over 24.

What is the best free Excel time tracking template?

The built-in Time Card template is the most reliable because it’s pre-tested by Microsoft. For a more detailed tracker, the Project time tracker is also good. If you want a custom one, the simple layout in this article works well.

Can I use Excel templates on Google Sheets?

Yes, you can upload an Excel template to Google Sheets and it will convert most formulas. However, some advanced Excel features (like certain data validation) may not work. Google Sheets also has its own time tracking templates in the Template Gallery.

How do I add a timer button to my Excel timesheet?

You can create a simple VBA macro that inserts the current time into a selected cell. For example, assign a button to this macro:

Sub InsertTime()
    ActiveCell.Value = Time
End Sub

Remember to save your workbook as a macro-enabled file (.xlsm) and always keep a backup copy before running macros.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.