Mastering Excel Timesheets: A Step-by-Step Guide

Gregory Jul 09, 2026

Keeping track of your work hours can be a daunting task, but with the right tools, it can become a breeze. Microsoft Excel, a powerful spreadsheet software, offers an efficient way to create and manage timesheets. In this guide, we'll walk you through the process of creating a timesheet in Excel, ensuring you stay organized and on top of your hours.

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

Before we dive in, ensure you have Microsoft Excel installed on your computer. If you're using a Mac, you can find Excel in the Applications folder or by searching for it in Spotlight. For Windows users, you can access Excel through the Start menu or by searching for it in the taskbar.

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

Setting Up Your Timesheet

To begin, open a new or existing workbook in Excel. For a clean start, click on 'File' in the top-left corner, then select 'New', and choose 'Blank workbook'.

How to Make a Time Sheet in Excel (with Formulas and Templates)
How to Make a Time Sheet in Excel (with Formulas and Templates)

Next, rename the sheet to 'Timesheet'. To do this, right-click on the sheet tab at the bottom, select 'Rename', and type in 'Timesheet'.

Creating Headers

13 Top Timesheet Templates
13 Top Timesheet Templates

In the first row (A1 to G1), create headers for your timesheet. These should include 'Date', 'Project/Task', 'Start Time', 'End Time', 'Duration', 'Rate', and 'Total'.

To make your headers stand out, apply a fill color. Select the cells (A1 to G1), click on the 'Home' tab, then click on the 'Fill' icon in the 'Font' group. Choose a color from the palette that appears.

Formatting Cells

Free Timesheet Templates for Excel, Google Sheets & PDF
Free Timesheet Templates for Excel, Google Sheets & PDF

Format the 'Duration', 'Rate', and 'Total' columns as currency. Select these cells (E1 to G1), click on the 'Home' tab, then click on the 'Number' group's 'Currency' icon.

For the 'Start Time' and 'End Time' columns, apply the time format. Select these cells (C1 to D1), click on the 'Home' tab, then click on the 'Number' group's 'Time' icon.

Entering Timesheet Data

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

Now that your timesheet is set up, it's time to start entering your work hours. Each row will represent a single work session.

In the 'Date' column (A2 and onwards), enter the dates for each work session. You can use the 'AutoFill' feature to quickly fill in dates. Select the first date, then drag the small square in the bottom-right corner of the cell down to the last date.

How to Create a Timestamp in Excel
How to Create a Timestamp in Excel
Best 5 Timesheet Templates for Accurate Time Tracking in 2026 - Excel Word Template
Best 5 Timesheet Templates for Accurate Time Tracking in 2026 - Excel Word Template
The 13 Best Timesheet Templates to Track Your Hours
The 13 Best Timesheet Templates to Track Your Hours
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
Elapsed Time Excel
Elapsed Time Excel
a spreadsheet showing the company name and timesheet
a spreadsheet showing the company name and timesheet
Progress Tracker in Excel – Visualize Your Goals & Milestones
Progress Tracker in Excel – Visualize Your Goals & Milestones
How to Create Timesheets in Excel: A Complete Walkthrough
How to Create Timesheets in Excel: A Complete Walkthrough
Monthly Time Sheets - 10 Free PDF Printables | Printablee
Monthly Time Sheets - 10 Free PDF Printables | Printablee
Excel Time Sheet with Overtime 😍 Easy Formula (Beginner to Pro)
Excel Time Sheet with Overtime 😍 Easy Formula (Beginner to Pro)
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
Timesheet
Timesheet
Work Timesheet Excel | Templates at allbusinesstemplates.com
Work Timesheet Excel | Templates at allbusinesstemplates.com
Excel Timesheet Calculator Template [FREE DOWNLOAD]
Excel Timesheet Calculator Template [FREE DOWNLOAD]
the excel time and date sheet
the excel time and date sheet
Simple Timesheet Tracker Excel Spreadsheet, Track Billable Hours Excel
Simple Timesheet Tracker Excel Spreadsheet, Track Billable Hours Excel
Free Timesheet Template for Excel
Free Timesheet Template for Excel
FREE Timesheet Templates for Employers
FREE Timesheet Templates for Employers
2.2M views · 22K reactions | Time Worked in Excel! #tutorial | CheatSheets | Facebook
2.2M views · 22K reactions | Time Worked in Excel! #tutorial | CheatSheets | Facebook
EVERYTHING about working with Dates & Time in Excel
EVERYTHING about working with Dates & Time in Excel

Calculating Duration

In the 'Start Time' and 'End Time' columns (C2 and D2), enter the start and end times for each work session. Excel will automatically calculate the duration based on these times.

To verify, select a cell in the 'Duration' column (E2), then look at the formula bar at the top of the screen. You should see a formula like '=D2-C2'. This calculates the duration by subtracting the start time from the end time.

Calculating Total

In the 'Rate' column (F2 and onwards), enter your hourly rate. In the 'Total' column (G2 and onwards), Excel will automatically calculate the total amount earned for each work session based on the duration and rate.

To verify, select a cell in the 'Total' column (G2), then look at the formula bar. You should see a formula like '=E2*F2'. This calculates the total by multiplying the duration by the rate.

Formatting and Customizing Your Timesheet

To make your timesheet more readable, you can apply banded rows or alternating row colors. Select the cells you want to format (A1 to G100, for example), then click on the 'Home' tab. In the 'Styles' group, click on the 'Format as Table' icon. Choose a table style with banded rows or alternating row colors.

You can also add a total row at the bottom to sum up your hours and earnings. Select the cells you want to sum (E2 to G100), then click on the 'Home' tab. In the 'Editing' group, click on the 'AutoSum' icon. Excel will insert a formula that sums the selected cells. Press 'Enter' to confirm.

Remember to save your work regularly. Click on 'File' in the top-left corner, then select 'Save As'. Choose a location to save your file and give it a name. You can also set up automatic saving by clicking on 'File', then 'Options', then 'Save'. Under 'Save files in this format', choose 'Excel Workbook (*.xlsx)', then under 'Save auto-recover info every', choose a time interval (like every 10 minutes).

Now that you've learned how to create and manage a timesheet in Excel, you can stay on top of your work hours with ease. Whether you're a freelancer, a small business owner, or an employee, a well-maintained timesheet can help you track your productivity, ensure accurate billing, and make informed decisions about your time. Happy tracking!