Mastering Excel: Step-by-Step Guide to Create a Timesheet

Gregory Jul 09, 2026

Keeping track of work hours can be a daunting task, especially when you're juggling multiple projects. Excel, with its robust features, can help streamline this process by creating a simple yet effective timesheet. Let's dive into how you can create a timesheet in Excel that will not only save you time but also provide valuable insights into your productivity.

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

Before we start, ensure you have Microsoft Excel installed on your computer. For this guide, we'll be using Excel 2016, but the steps are similar in other versions as well. Now, let's get started!

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

Setting Up the Basic Structure

First, open a new workbook in Excel. This will be the foundation of your timesheet. Next, name the sheet "Timesheet" for easy reference. To do this, right-click on the sheet tab at the bottom and select "Rename."

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

Now, let's set up the headers. In row 1, starting from column A, enter the following headers: "Date," "Project/Task," "Start Time," "End Time," and "Hours Worked." Format the "Date" column as "Short Date" for a clean look. To do this, select the column, right-click, and choose "Format Cells." Then, select "Short Date" under the "Number" tab.

Formatting the Timesheet

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

To make your timesheet visually appealing and easy to read, let's apply some formatting. Select the range A1:E100 (you can adjust this based on how many rows you think you'll need). Then, apply the following formatting:

  • Fill color: A light gray or any color that you find visually appealing.
  • Font: A clean, easy-to-read font like Calibri or Arial. Size 12 or 14.
  • Border: A thin, dark border around the cells to define them.

You can also add a filter to the headers to sort and filter data easily. To do this, select any cell in the range A1:E1, then click on the "Sort & Filter" button in the "Home" tab and select "Filter."

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

Automating Calculations

Excel's built-in functions can help automate the calculation of hours worked. In cell E2, enter the following formula: "=IFERROR((ENDTIME - STARTTIME), 0)" (without the quotes). This formula calculates the difference between the end time and start time and displays 0 if either field is empty. To apply this formula to the entire column, drag the small square in the bottom-right corner of the cell down to copy the formula.

Now, whenever you enter a start and end time, the hours worked will automatically calculate. Isn't that neat?

Part 1: Create a Basic Excel Timesheet
Part 1: Create a Basic Excel Timesheet

Tracking Your Time

Now that your timesheet is set up, it's time to start tracking your time. Here's how you can do it:

Progress Tracker in Excel โ€“ Visualize Your Goals & Milestones
Progress Tracker in Excel โ€“ Visualize Your Goals & Milestones
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
Work Timesheet Excel | Templates at allbusinesstemplates.com
Work Timesheet Excel | Templates at allbusinesstemplates.com
a spreadsheet showing the company name and timesheet
a spreadsheet showing the company name and timesheet
Excel Time Sheet with Overtime ๐Ÿ˜ Easy Formula (Beginner to Pro)
Excel Time Sheet with Overtime ๐Ÿ˜ Easy Formula (Beginner to Pro)
Elapsed Time Excel
Elapsed Time Excel
Create a timesheet in Excel
Create a timesheet in Excel
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
Free Timesheet Template for Excel
Free Timesheet Template for Excel
Free Timesheet Template for Excel
Free Timesheet Template for Excel
Create a timesheet in Excel
Create a timesheet 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
a screenshot of a project schedule in the exceltemple timesheet window
a screenshot of a project schedule in the exceltemple timesheet window
Free Timesheet Templates | Daily, Weekly, Monthly
Free Timesheet Templates | Daily, Weekly, Monthly
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
Download Multiple Employees Weekly Timesheet Excel Template - ExcelDataPro
Download Multiple Employees Weekly Timesheet Excel Template - ExcelDataPro
Boost Productivity With 141 Free Sheets
Boost Productivity With 141 Free Sheets
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
EVERYTHING about working with Dates & Time in Excel
EVERYTHING about working with Dates & Time in Excel
Project Milestone Chart Using Excel | MyExcelOnline
Project Milestone Chart Using Excel | MyExcelOnline

Each day, enter the current date in the "Date" column. Then, for each project or task, enter a brief description in the "Project/Task" column. Next, enter the start time in the "Start Time" column and the end time in the "End Time" column. The "Hours Worked" column will automatically update with the hours you've worked on that task.

Adding a Summary Sheet

To get a bird's-eye view of your productivity, let's add a summary sheet. Right-click on the sheet tab and select "Insert" to add a new sheet. Name it "Summary."

In cell A1, enter "Weekly Total Hours." In cell B1, enter the following formula: "=SUM(Timesheet!E2:E100)" (without the quotes). This formula adds up all the hours worked in the timesheet and displays the total in the summary sheet. You can adjust the range as needed.

Analyzing Your Data

Excel's built-in pivot tables and charts can help you analyze your data and gain insights into your productivity. To create a pivot table, select any cell in the timesheet, then go to the "Insert" tab and click on "PivotTable." Choose where you want to place the pivot table and click "OK."

In the "PivotTable Fields" pane, drag "Project/Task" to the "Rows" section and "Hours Worked" to the "Values" section. This will give you a breakdown of hours worked on each project. You can further customize the pivot table by adding filters, sorting, and grouping data.

Remember, consistency is key when it comes to time tracking. Make it a habit to fill in your timesheet every day, and you'll soon have a wealth of data to help you understand your productivity patterns and make informed decisions.

Now that you've created a comprehensive timesheet in Excel, it's time to put it to use. Happy tracking, and here's to increased productivity!