Create Simple Timesheet in Excel: Step-by-Step Guide

Gregory Jul 09, 2026

Ever found yourself manually tracking your work hours, only to realize you've spent more time on paperwork than actual work? A simple timesheet in Excel can streamline this process, saving you time and ensuring accurate record-keeping. Let's dive into creating a basic Excel timesheet tailored to your needs.

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

Before we begin, ensure you have Microsoft Excel installed on your computer. If you're using a different spreadsheet software, the principles remain the same, but the interface might differ slightly.

How to Create a Simple Excel Timesheet
How to Create a Simple Excel Timesheet

Setting Up Your Timesheet

First, let's create a basic structure for your timesheet. Open Excel and create a new workbook. In the first sheet, name it "Timesheet".

How to Create a Timestamp in Excel
How to Create a Timestamp in Excel

Next, label the headers for your timesheet. In Row 1, enter the following headers: "Date", "Project/Task", "Start Time", "End Time", and "Hours Worked". Format these headers as you like, using bold text and background color for better visibility.

Formatting Date Column

Excel - how to create timesheets
Excel - how to create timesheets

To keep your timesheet organized, format the "Date" column as an Excel date. Select the column, click on "Home" in the ribbon, then "Format as Table". Choose "Short Date" under "Number" and click "OK".

This ensures your dates are consistently formatted and makes sorting and filtering easier.

Formatting Time Columns

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

Format the "Start Time" and "End Time" columns as time. Select the columns, click on "Home" in the ribbon, then "Format as Table". Choose "Time" under "Number" and click "OK".

This ensures your times are consistently formatted and makes calculations accurate.

Automating Calculations

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

Now, let's make your timesheet work for you by automating calculations. In Row 2, enter the following formulas:

- In cell B2 (Project/Task), enter the task or project you're working on.

Simple Excel Timesheet
Simple Excel Timesheet
Free Timesheet Templates | Daily, Weekly, Monthly
Free Timesheet Templates | Daily, Weekly, Monthly
Work Timesheet Excel | Templates at allbusinesstemplates.com
Work Timesheet Excel | Templates at allbusinesstemplates.com
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)
an invoice form for employees to pay
an invoice form for employees to pay
2.2M views ยท 22K reactions | Time Worked in Excel! #tutorial | CheatSheets | Facebook
2.2M views ยท 22K reactions | Time Worked in Excel! #tutorial | CheatSheets | Facebook
Boost Productivity With 141 Free Sheets
Boost Productivity With 141 Free Sheets
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
Time Sheet Calculator in Excel
Time Sheet Calculator in Excel
How to Create a Timesheet in Excel to Track Time (+Templates)
How to Create a Timesheet in Excel to Track Time (+Templates)
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
Project Milestone Chart Using Excel | MyExcelOnline
Project Milestone Chart Using Excel | MyExcelOnline
Daily Work Tracker Excel: Essential Functions for Better Planning
Daily Work Tracker Excel: Essential Functions for Better Planning
FREE 26+ Payroll Templates in Excel
FREE 26+ Payroll Templates in Excel
Top 101 Excel Templates for Productivity
Top 101 Excel Templates for Productivity
Add Minutes to Time in Excel
Add Minutes to Time in Excel
Best Excel tutorial on the internet
Best Excel tutorial on the internet
how to calculate hours worked
how to calculate hours worked
15 Free Timesheet Templates [Excel, Word, PDF] แ… TemplateLab
15 Free Timesheet Templates [Excel, Word, PDF] แ… TemplateLab

- In cell C2 (Start Time), enter the start time for the task.

- In cell D2 (End Time), enter the end time for the task.

Calculating Hours Worked

In cell E2 (Hours Worked), enter the following formula to calculate the hours worked based on start and end times:

`=IF(D2

This formula subtracts the start time from the end time. If the end time is earlier than the start time, it returns an empty cell.

Drag this formula down to copy it for other rows. Now, your timesheet automatically calculates the hours worked for each task.

Totaling Hours Worked

To see your total hours worked, enter the following formula in a cell below the "Hours Worked" column:

`=SUM(E2:E100)`

This formula sums up all the hours worked from Row 2 to Row 100. You can adjust the range as needed.

Format this cell as currency or percentage, depending on your preference. This gives you a quick overview of your total hours worked.

With your timesheet set up, you can now track your hours worked efficiently. Regularly update your timesheet to maintain accurate records. This not only saves you time but also provides valuable data for future planning and billing.

Remember, the key to an effective timesheet is consistency. Make it a habit to update your timesheet daily, and you'll soon reap the benefits of organized time management.