Track Hours Worked in Excel: A Step-by-Step Guide

Gregory Jul 09, 2026

Keeping track of hours worked is a crucial aspect of project management, freelancing, or simply monitoring your productivity. While there are numerous apps and software designed for this purpose, Microsoft Excel, a widely-used spreadsheet program, can also be an effective tool. Here's a step-by-step guide on how to track hours worked in Excel, ensuring your time is accounted for accurately and efficiently.

Employee Time Tracking in Excel (+ video tutorial!)
Employee Time Tracking in Excel (+ video tutorial!)

Excel's versatility and customization options make it an excellent choice for tracking hours. Whether you're a project manager overseeing a team or a freelancer billing clients, you can create a simple yet powerful timesheet to monitor your hours. Let's dive into the process.

How to Calculate Hours Worked in Excel
How to Calculate Hours Worked in Excel

Setting Up Your Timesheet

Before you start tracking hours, you need to set up your timesheet. This involves creating a spreadsheet that includes relevant columns for tracking your time.

How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy

Here are the essential columns to include in your timesheet:

  • Date: The date when the work was done.
  • Start Time: The time you began working.
  • End Time: The time you finished working.
  • Duration: The total hours worked (calculated automatically).
  • Project/Task: A brief description of what you were working on.
  • Notes: Any relevant notes or details about the work done.
Free Timesheet Templates for Excel, Google Sheets & PDF
Free Timesheet Templates for Excel, Google Sheets & PDF

Formatting Your Timesheet

To make your timesheet more user-friendly and easier to read, consider the following formatting tips:

Use the Time format for the Start Time and End Time columns to display hours and minutes. You can do this by right-clicking the column header, selecting Format Cells, then Custom, and entering the format as [h]:mm.

How to Keep Track of Your Work Hours
How to Keep Track of Your Work Hours

Calculating Duration

To automatically calculate the duration of each work session, you can use the TIME function in Excel. In the Duration column, enter the formula:

=TIME(END TIME - START TIME)

How to Calculate Hours Worked Minus Lunch Using Excel Formulas (4 Methods) - ExcelDemy
How to Calculate Hours Worked Minus Lunch Using Excel Formulas (4 Methods) - ExcelDemy

This formula subtracts the start time from the end time and converts the result into hours and minutes.

Tracking Your Hours

How to Make a Time Sheet in Excel (with Formulas and Templates)
How to Make a Time Sheet in Excel (with Formulas and Templates)
Working Hours Template
Working Hours Template
Calculate work hours
Calculate work hours
How to calculate work hours in Excel
How to calculate work hours in Excel
How To Count Or Calculate Hours Worked In Excel
How To Count Or Calculate Hours Worked In Excel
Employee Time Sheet Template for Excel & Google Sheets โ€“ Track Hours & Schedules Effortlessly
Employee Time Sheet Template for Excel & Google Sheets โ€“ Track Hours & Schedules Effortlessly
Daily Task Tracker Excel Template | Employee Timesheet Time Tracker | Work Hours Log Google Sheets
Daily Task Tracker Excel Template | Employee Timesheet Time Tracker | Work Hours Log Google Sheets
Payment Calendar Excel Template โ€“ Streamline Your Work Hours Tracking Today
Payment Calendar Excel Template โ€“ Streamline Your Work Hours Tracking Today
Excel Time Sheet with Overtime ๐Ÿ˜ Easy Formula (Beginner to Pro)
Excel Time Sheet with Overtime ๐Ÿ˜ Easy Formula (Beginner to Pro)
107K views ยท 1.5K reactions | Calculating Worked Hours Using Formula!! #Excel | Excelling At Excel
107K views ยท 1.5K reactions | Calculating Worked Hours Using Formula!! #Excel | Excelling At Excel
10 Best Timesheet Templates to Track Work Hours
10 Best Timesheet Templates to Track Work Hours
Simple Timesheet Tracker Excel Spreadsheet, Track Billable Hours Excel
Simple Timesheet Tracker Excel Spreadsheet, Track Billable Hours Excel
Work Hours Tracker | Excel & Google Sheets Timesheet Template | Employee Attendance Log | Editable Work Schedule Spreadsheet
Work Hours Tracker | Excel & Google Sheets Timesheet Template | Employee Attendance Log | Editable Work Schedule Spreadsheet
FREE Excel Timesheet Template [DOWNLOAD]
FREE Excel Timesheet Template [DOWNLOAD]
ROTA Template
ROTA Template
Efficient Absence & Vacation Tracker for Staff & Students in Excel
Efficient Absence & Vacation Tracker for Staff & Students in Excel
Google Sheets Work Timesheet Template: Employee Time Tracker (Weekly)
Google Sheets Work Timesheet Template: Employee Time Tracker (Weekly)
Add Time enter for Timesheet
Add Time enter for Timesheet
Time Sheet Calculator in Excel
Time Sheet Calculator in Excel
Daily Work Schedule Checklist Template in Excel
Daily Work Schedule Checklist Template in Excel

Now that your timesheet is set up, it's time to start tracking your hours. Here's how to fill in your timesheet as you work:

Starting a New Entry

When you begin working on a task, enter the current date and start time in the respective columns. If you have a specific project or task to work on, enter that in the Project/Task column. You can add any relevant notes in the Notes column.

Ending a Work Session

Once you've finished working on a task, enter the end time in the End Time column. The Duration column will automatically calculate the total hours worked based on the start and end times.

Analyzing Your Hours

After tracking your hours for some time, you might want to analyze the data to gain insights into your productivity or billing patterns. Excel provides several ways to do this:

Sorting and Filtering

You can sort your timesheet by date, project, or duration to quickly identify trends or patterns. Use the Sort & Filter button in the Home tab to sort your data, and click the filter icon in the column header to apply filters.

Using PivotTables

PivotTables allow you to summarize and analyze your data in a more meaningful way. You can create a PivotTable to display the total hours worked per project, per week, or per month. To create a PivotTable, select your data, click the Insert tab, and then click PivotTable. Drag and drop the relevant fields into the rows, columns, and values areas to create your summary.

Tracking hours worked in Excel is a straightforward process that can help you maintain a clear record of your time. By setting up a well-organized timesheet and using Excel's built-in features, you can effectively monitor your productivity and make data-driven decisions. So, start tracking your hours today and watch your productivity soar!