Excel Timesheet Formula: Track Hours Worked Efficiently

Gregory Jul 09, 2026

Keeping track of hours worked is a crucial aspect of project management and billing. While there are numerous tools available to accomplish this, Microsoft Excel remains a popular choice due to its flexibility and widespread use. One of the most efficient ways to track hours in Excel is by using timesheet formulas. Let's explore how to create an effective timesheet using Excel formulas for hours worked.

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

Before we dive into the formulas, let's set up a basic timesheet structure. You'll need columns for the date, project or task name, hours worked, and any additional details like overtime or billable status. Here's a simple layout to get started:

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

Creating the Timesheet Structure

To create a timesheet, start by labeling your columns. In the first row, enter the following headers:

FREE Excel Timesheet Template [DOWNLOAD]
FREE Excel Timesheet Template [DOWNLOAD]
  • Date
  • Project/Task
  • Hours Worked
  • Overtime (optional)
  • Billable (Yes/No)

Formatting Date Column

the weekly time sheet is shown in red and green
the weekly time sheet is shown in red and green

To make data entry easier, format the 'Date' column as an Excel date. This allows you to use the Today() function later on. To do this, select the column, click on 'Number Format' in the 'Home' tab, and choose 'Short Date'.

Now, you're ready to start entering data and using formulas to calculate hours worked.

Automatically Populating Dates

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

To save time, you can use the Today() function to automatically populate the current date. In the second row of the 'Date' column, enter the following formula:

=TODAY()

Then, drag the formula down to copy it for each day. This ensures your timesheet always starts with the current date.

Excel Timesheet Calculator Template [FREE DOWNLOAD]
Excel Timesheet Calculator Template [FREE DOWNLOAD]

Tracking Hours Worked

Now that your timesheet is set up, let's look at how to track hours worked using Excel formulas.

Calculate Production Per Hour in Excel
Calculate Production Per Hour in Excel
Add Time enter for Timesheet
Add Time enter for Timesheet
How to calculate work hours in Excel
How to calculate work hours in Excel
Calculate hours between two times!
Calculate hours between two times!
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
How to Make a Time Sheet in Excel (with Formulas and Templates)
How to Make a Time Sheet in Excel (with Formulas and Templates)
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
Time Sheet Template with Breaks
Time Sheet Template with Breaks
how to calculate hours worked
how to calculate hours worked
Calculate work hours
Calculate work hours
an excel spreadsheet showing the time and date for each project in one column
an excel spreadsheet showing the time and date for each project in one column
706K views · 5.2K reactions | Learn how to set up a simple timesheet that automatically calculates Total Hours, Regular Hours, and Overtime—perfect for payroll or attendance tracking. Formula Used: Total Hours:  =IF(((F9 - C9) - (E9 - D9)) * 24 > 0,     ((F9 - C9) - (E9 - D9)) * 24,     \
706K views · 5.2K reactions | Learn how to set up a simple timesheet that automatically calculates Total Hours, Regular Hours, and Overtime—perfect for payroll or attendance tracking. Formula Used: Total Hours: =IF(((F9 - C9) - (E9 - D9)) * 24 > 0, ((F9 - C9) - (E9 - D9)) * 24, \
robot88 : Situs Game Online  Deposit Pulsa dengan potongan Terbaik
robot88 : Situs Game Online Deposit Pulsa dengan potongan Terbaik
robot88 : Situs Game Online  Deposit Pulsa dengan potongan Terbaik
robot88 : Situs Game Online Deposit Pulsa dengan potongan Terbaik
How to Calculate Over Time in Excel 🔥#excel #shortsvideo #exceltips #tipsntricks #exceltutorial
How to Calculate Over Time in Excel 🔥#excel #shortsvideo #exceltips #tipsntricks #exceltutorial
the calculator timesheets in excel
the calculator timesheets in excel
Time Sheet Template with Breaks
Time Sheet Template with Breaks
how to calculate hours worked in excel - tips by michael schreck
how to calculate hours worked in excel - tips by michael schreck
robot88 : Situs Game Online  Deposit Pulsa dengan potongan Terbaik
robot88 : Situs Game Online Deposit Pulsa dengan potongan Terbaik
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

Entering Hours Manually

For simple timesheets, you can enter hours worked manually in the 'Hours Worked' column. However, for more complex tracking, consider using the following formulas:

Using SUMIF Function for Multiple Projects

If you're working on multiple projects, you can use the SUMIF function to total hours worked for each project. In a new row below your data, enter the project name in the 'Project/Task' column. Then, in the 'Hours Worked' column, use the following formula:

=SUMIF($B$2:$B$100, A2, $C$2:$C$100)

This formula sums the hours worked for the project specified in cell A2. The range $B$2:$B$100 is the list of projects, and $C$2:$C$100 is the list of hours worked.

Calculating Total Hours Worked

To find the total hours worked for the entire timesheet, use the SUM function in a new row at the bottom. In the 'Hours Worked' column, enter:

=SUM(C2:C100)

This formula adds up all the hours in the 'Hours Worked' column from row 2 to 100.

With these formulas, you can create an efficient timesheet to track hours worked in Excel. Regularly updating your timesheet will help you maintain accurate records and make billing a breeze. Happy tracking!