Excel Spreadsheet Templates for Tracking Time

How-to basics · Updated November 22, 2026

The quickest way to track time in Excel is to use a pre-built template that logs start time, end time, and total hours per task, then sums them for the day or week. Microsoft 365 includes several free time-tracking templates under File > New, and you can also download them from the official Microsoft Create site. Below is a practical guide to what these templates contain, how to adapt them, and when a spreadsheet is the wrong tool.

What Time-Tracking Templates Actually Do

Most Excel time templates share a common structure: a table with columns for Date, Task or Project, Start Time, End Time, and sometimes Break Duration. A formula like =IF(C2>B2, C2-B2, C2+1-B2) calculates the elapsed time, handling shifts that cross midnight. The template then sums those daily totals into a weekly or monthly view, often with a simple bar chart.

For example, the classic “Time Card” template in Microsoft 365 uses a weekly grid with daily rows for regular and overtime hours. You enter clock-in and clock-out times, and the template calculates total hours and pay based on an hourly rate you set in a cell. Another common one, the “Weekly Time Sheet,” has separate columns for each day and a total row at the bottom.

How to Find and Open These Templates

In Excel for Microsoft 365 on Windows, click File > New and type “time” or “timesheet” into the search box. You’ll see options like “Time Card,” “Weekly Time Sheet,” “Monthly Time Sheet,” and “Project Time Tracker.” Click one and then click Create. The same process works on Mac (File > New from Template) and in Excel for the web (File > New), though the template gallery is slightly smaller online.

If you prefer a downloadable file, go to templates.office.com (now part of Microsoft Create) and search for “time tracking.” Download the .xlsx file and open it in Excel. These templates are fully editable, so you can rename columns, change the date range, or add your own formulas.

Customizing a Template for Your Needs

Most users need to tweak the template. The most common changes are:

  • Adding a column for client or project name – insert a new column and label it, then include it in any SUMIF formulas.
  • Changing the pay rate – find the cell that holds the hourly rate (often named “Rate” or “Hourly”) and update it.
  • Adding a break deduction – insert a column for break minutes and subtract it from the total hours using a formula like =((D2-C2)*24) - (E2/60) where D is end time, C is start time, and E is break minutes.
  • Switching from weekly to monthly – many templates already have monthly versions; if not, copy the weekly sheet and change the date headers.

Remember that Excel stores times as fractions of a day. So 12:00 PM is 0.5, and 6:00 PM is 0.75. To get hours as a decimal number, multiply the difference by 24. For instance, if start time is in C2 and end time in D2, the formula =(D2-C2)*24 returns 8 for an 8-hour shift. Format the result cell as a number, not as a time.

Common Problems and How to Fix Them

One frequent issue is that total hours appear as something like 0.333 instead of 8:00. That happens when the result cell is formatted as a time. Select the cell, press Ctrl+1 (or Cmd+1 on Mac), choose Number or General, and increase decimal places if needed.

Another problem is that overnight shifts return negative values. The formula =IF(D2>C2, D2-C2, D2+1-C2) handles that by adding 1 (a full day) when the end time is earlier than the start time. For example, start at 10:00 PM and end at 6:00 AM: the formula gives 8 hours.

If your template uses a dropdown list for tasks, but you want to add new tasks, go to the cell with the dropdown, click Data > Data Validation, and edit the Source box to include the new item. On Mac, it’s Data > Data Validation as well.

Comparing Excel Templates to Dedicated Time-Tracking Apps

Excel templates work well for simple, individual tracking – a freelancer logging hours per client, a student tracking study time, or a small team with a shared workbook. They are free, offline, and fully customizable. However, they have clear limitations:

  • No automatic timer – you must manually enter start and end times, which is easy to forget.
  • No mobile app with offline sync – Excel mobile exists, but syncing a shared file can be clunky.
  • No built-in reporting beyond basic charts – you can build pivot tables, but it takes effort.
  • No approval workflow – if a manager needs to approve timesheets, a web-based tool like Toggl Track or Clockify does that out of the box.

For a single user tracking a few hours a day, Excel is often enough. For a team of 10 or more, or if you need to track time in real time, a dedicated app saves hours of manual entry.

Costs and Safety Considerations

Excel templates themselves are free – either included with your Microsoft 365 subscription or as free downloads from Microsoft Create. The only cost is your Excel license, which starts around $6 per user per month for Microsoft 365 Personal. If you’re using Excel for the web, it’s free with a Microsoft account, but you’ll need to store the file in OneDrive.

When sharing a time-tracking workbook, be careful with sensitive data like hourly rates or total pay. If you send it via email, consider removing the pay columns or password-protecting the file (File > Info > Protect Workbook > Encrypt with Password). Also, avoid using macros in shared templates unless you trust the source – macros can contain harmful code. Only enable macros from files you downloaded from a reputable site like Microsoft’s official template gallery.

Alternatives Within Excel: Built-in Functions and Manual Tables

If you don’t want a template, you can build your own tracker from scratch. Start with a table that has columns for Date, Start, End, and Task. Use the formulas mentioned above to calculate hours. Then create a pivot table to summarize by task or week. This gives you full control but takes about 15 minutes to set up.

Another Excel-native option is to use a simple table with a “Time” column where you type durations directly (e.g., 1.5 for 1.5 hours). That’s less accurate but faster for rough tracking. You can also use the TEXT function to format hours as “8h 30m” with a formula like =TEXT(D2-C2,

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.