How to Create a Timesheet in Excel Step by Step

Gregory Jul 09, 2026

Keeping track of work hours can be a daunting task, especially when done manually. However, with Microsoft Excel, creating a timesheet becomes a breeze. This step-by-step guide will walk you through the process of creating a timesheet in Excel, ensuring you have a clear and organized record of your work hours.

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

Before we dive into the steps, make sure you have Microsoft Excel installed on your computer. If not, you can download a free trial or use the web-based version of Excel, Microsoft 365, which also offers a free trial.

How to Make a Timesheet in Excel - Tutorial
How to Make a Timesheet in Excel - Tutorial

Setting Up Your Timesheet

To begin, open a new or existing workbook in Excel. For this guide, let's assume you're starting with a new workbook.

How to Create Timesheets in Excel: A Complete Walkthrough
How to Create Timesheets in Excel: A Complete Walkthrough

In the first row (Row 1), enter the following headers: 'Date', 'Start Time', 'End Time', 'Hours Worked', and 'Notes'. These headers will serve as the title for each column in your timesheet.

Formatting Your Timesheet

the calculator timesheets in excel
the calculator timesheets in excel

To make your timesheet visually appealing and easy to read, apply some basic formatting. Select the range A1:E1 (the headers you just created), then click on the 'Fill Color' icon in the 'Home' tab of the ribbon. Choose a light color to highlight the headers.

Next, select the range A2:E100 (assuming you'll track your hours for at least 100 days). Click on the 'Format as Table' icon in the 'Home' tab. Choose a table style that suits your preference. This will apply a consistent format to your timesheet and make it easier to manage.

Formatting Date and Time Columns

Excel Timesheet Calculator
Excel Timesheet Calculator

To ensure accurate calculations, format the 'Date', 'Start Time', and 'End Time' columns as follows:

1. Select the 'Date' column (Column A). Click on the 'Number' group in the 'Home' tab, then select 'Short Date'.

2. Select the 'Start Time' and 'End Time' columns (Columns B and C). Click on the 'Number' group in the 'Home' tab, then select 'Time'.

a spreadsheet showing the company name and timesheet
a spreadsheet showing the company name and timesheet

Calculating Hours Worked

Now that your timesheet is set up, let's create a formula to calculate the hours worked each day.

How to Make a Time Sheet in Excel (with Formulas and Templates)
How to Make a Time Sheet in Excel (with Formulas and Templates)
Work Timesheet Excel | Templates at allbusinesstemplates.com
Work Timesheet Excel | Templates at allbusinesstemplates.com
Step-by-Step Guide to Timesheet Template Excel
Step-by-Step Guide to Timesheet Template Excel
The 13 Best Timesheet Templates to Track Your Hours
The 13 Best Timesheet Templates to Track Your Hours
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
Elapsed Time Excel
Elapsed Time Excel
Excel Time Sheet with Overtime 😍 Easy Formula (Beginner to Pro)
Excel Time Sheet with Overtime 😍 Easy Formula (Beginner to Pro)
Create a timesheet in Excel
Create a timesheet in Excel
Add Time enter for Timesheet
Add Time enter for Timesheet
How to Calculate Over Time in Excel 🔥#excel #shortsvideo #exceltips #tipsntricks #exceltutorial
How to Calculate Over Time in Excel 🔥#excel #shortsvideo #exceltips #tipsntricks #exceltutorial
How to Create a Timesheet in Excel to Track Time (+Templates)
How to Create a Timesheet in Excel to Track Time (+Templates)
Weekly time sheet template | Time card in Excel | Employees Time sheet in Excel | learning Center
Weekly time sheet template | Time card in Excel | Employees Time sheet in Excel | learning Center
Project Milestone Chart Using Excel | MyExcelOnline
Project Milestone Chart Using Excel | MyExcelOnline
the excel time and date sheet
the excel time and date sheet
Calender in Excel ‼️ Amazing Excel trick using data validation and conditional formatting ✅ #Excel
Calender in Excel ‼️ Amazing Excel trick using data validation and conditional formatting ✅ #Excel
Download Multiple Employees Weekly Timesheet Excel Template - ExcelDataPro
Download Multiple Employees Weekly Timesheet Excel Template - ExcelDataPro
Time Sheet Calculator in Excel
Time Sheet Calculator in Excel
2.2M views · 22K reactions | Time Worked in Excel! #tutorial | CheatSheets | Facebook
2.2M views · 22K reactions | Time Worked in Excel! #tutorial | CheatSheets | Facebook
How to Create a Timestamp in Excel
How to Create a Timestamp in Excel
How To Make TIME SHIFT SCHEDULE / OVER TIME in Excel
How To Make TIME SHIFT SCHEDULE / OVER TIME in Excel

In cell D2, enter the following formula: `=IFERROR(TIME(C2-B2, "h:mm"), "")`. This formula calculates the difference between the 'End Time' and 'Start Time' for each day. If there's no value in either cell, it will display an empty cell.

Formatting Hours Worked Column

To make the 'Hours Worked' column easier to read, format it as follows:

1. Select the 'Hours Worked' column (Column D). Click on the 'Number' group in the 'Home' tab, then select 'Time'.

2. Click on the 'Decrease Decimal' icon in the 'Number' group until only hours and minutes are displayed.

Adding a Total Row

To keep track of your total hours worked, add a total row at the bottom of your timesheet. In cell D1, enter the following formula: `=SUM(D2:D100)`. This formula adds up all the hours worked in the range D2:D100.

Congratulations! You've successfully created a timesheet in Excel. Regularly updating your timesheet will help you maintain an accurate record of your work hours. If you need to add or remove days, simply adjust the range in the formulas accordingly.

Remember, consistency is key when it comes to tracking your work hours. Make it a habit to fill in your timesheet at the end of each day. This will not only help you keep track of your hours but also provide valuable insights into your productivity patterns.