Excel Timesheet: Calculate Total Hours Easily

Gregory Jul 09, 2026

Keeping track of work hours is a crucial aspect of project management and employee productivity. Excel, with its robust features, is an excellent tool for creating timesheets and calculating total hours worked. In this guide, we'll explore how to create an effective timesheet in Excel and calculate the total hours worked.

Timesheet for worked hours 2015 v3 with total hours per project
Timesheet for worked hours 2015 v3 with total hours per project

Before we dive into the details, ensure you have a basic understanding of Excel. Familiarize yourself with cells, rows, and columns, as they form the foundation of any Excel task.

The 13 Best Timesheet Templates to Track Your Hours
The 13 Best Timesheet Templates to Track Your Hours

Creating an Excel Timesheet

An Excel timesheet typically includes columns for dates, tasks, hours worked, and any additional details like breaks or overtime. Here's a simple way to set up your timesheet:

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

1. In the first row, create headers: 'Date', 'Task', 'Start Time', 'End Time', 'Break (minutes)', and 'Total Hours'.

Formatting Date and Time Columns

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

Formatting these columns as dates and times ensures accurate calculations and better readability.

1. Select the 'Date' column, right-click, and select 'Format Cells'. Choose 'Custom' and enter the date format you prefer (e.g., 'yyyy-mm-dd').

2. For 'Start Time' and 'End Time', select the columns, right-click, and choose 'Format Cells'. Under 'Number', select 'Time'. You can customize the format (e.g., 'hh:mm am/pm').

Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet

Calculating Total Hours

To calculate the total hours worked each day, use the following formula in the 'Total Hours' column:

`=((End Time - Start Time) - (Break / 60))`

the printable timesheet calculator is shown in this file, and it contains
the printable timesheet calculator is shown in this file, and it contains

This formula subtracts the start time from the end time, then subtracts the break time (divided by 60 to convert minutes to hours).

Calculating Total Hours Worked

How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
10 Best Timesheet Templates to Track Work Hours
10 Best Timesheet Templates to Track Work Hours
Time Sheet Template with Breaks
Time Sheet Template with Breaks
Editable Excel Employee Time Sheet, Weekly Time Tracker,  Timekeeping Sheet, Time Log
Editable Excel Employee Time Sheet, Weekly Time Tracker, Timekeeping Sheet, Time Log
13 Top Timesheet Templates
13 Top Timesheet Templates
Project Time Tracking Excel Template — Automated Timesheet for Work Hours & Billing
Project Time Tracking Excel Template — Automated Timesheet for Work Hours & Billing
Monthly Excel Timesheet Template | Editable & Automated Work Hour Tracker | Job Log Spreadsheet | Instant Download
Monthly Excel Timesheet Template | Editable & Automated Work Hour Tracker | Job Log Spreadsheet | Instant Download
the printable timesheet for employees is shown in purple and white, as well as
the printable timesheet for employees is shown in purple and white, as well as
Janetemplateweeklytimesheettemplate
Janetemplateweeklytimesheettemplate
FREE Excel Timesheet Template [DOWNLOAD]
FREE Excel Timesheet Template [DOWNLOAD]
Weekly Time Sheet, Employee Time Tracker, Clock in and Out Timesheet, Freelancer Template, Trucking Time Sheet Template Excel Spreadsheet - Etsy
Weekly Time Sheet, Employee Time Tracker, Clock in and Out Timesheet, Freelancer Template, Trucking Time Sheet Template Excel Spreadsheet - Etsy
Timesheet Complete Software Excel | Total Hour Total Over time and Pay
Timesheet Complete Software Excel | Total Hour Total Over time and Pay
Weekly Timesheet Template: Editable Excel Time Card (US Letter)
Weekly Timesheet Template: Editable Excel Time Card (US Letter)
Add Time enter for Timesheet
Add Time enter for Timesheet
ROTA Template
ROTA Template
Free Timesheet Template for Excel | Budget Spreadsheet Types By Timeframe, Excel Bill Payment
Free Timesheet Template for Excel | Budget Spreadsheet Types By Timeframe, Excel Bill Payment
Work Schedule - 10 Free PDF Printables | Printablee
Work Schedule - 10 Free PDF Printables | Printablee
How to Make a Time Sheet in Excel (with Formulas and Templates)
How to Make a Time Sheet in Excel (with Formulas and Templates)

Once your timesheet is set up, calculating the total hours worked over a specific period is straightforward.

1. In a new cell, enter the formula `=SUM(Total Hours)` to sum up all the hours worked in the timesheet.

Filtering Dates

If you want to calculate the total hours for a specific date range, use the 'AutoFilter' feature:

1. Click on the 'Date' column header to select the entire column.

2. Click on the 'Filter' icon (looks like a funnel) at the top of the column. Select the dates you want to include in your calculation.

3. The 'SUM' formula will now only include the hours worked within the selected date range.

Regularly updating and maintaining your Excel timesheet ensures accurate tracking of work hours. This not only helps in project planning and billing but also provides valuable insights into productivity and workload.

Remember, consistency is key when using Excel for timesheets. Ensure all team members follow the same format and update their timesheets regularly to maintain accurate records.

Happy tracking, and here's to productive days ahead!