Mastering Excel: Step-by-Step Guide to Adding Timesheets

Gregory Jul 09, 2026

Keeping track of work hours is a crucial aspect of project management and billing. While there are numerous tools available for time tracking, Microsoft Excel remains a popular choice due to its versatility and widespread use. If you're wondering how to add a timesheet in Excel, you're in the right place. In this guide, we'll walk you through the process step by step, ensuring you have a functional and efficient timesheet to manage your hours.

Create Timesheet Calculator in Excel
Create Timesheet Calculator in Excel

Before we dive into the details, let's ensure you have a basic understanding of Excel. Familiarize yourself with the ribbon at the top of the screen, which contains various tabs like Home, Insert, Page Layout, etc. We'll be using the Home tab and the Insert tab for this tutorial.

Add Minutes to Time in Excel
Add Minutes to Time in Excel

Setting Up Your Timesheet

To begin, let's create a simple timesheet template. We'll use a table format for easy data organization and manipulation.

How to add time with hours/minutes/seconds increments in Excel?
How to add time with hours/minutes/seconds increments in Excel?

First, click on the 'Insert' tab in the ribbon. Then, click on 'Table' and select 'OK' when prompted. This will create a table with a single row and column. We'll expand this table to fit our needs.

Adding Columns

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

To add columns, right-click on the table and select 'Insert' from the context menu. Choose 'Insert Columns to the Left' or 'Insert Columns to the Right' depending on where you want to add the new column. Repeat this process to add the following columns:

  • Date
  • Start Time
  • End Time
  • Duration (in hours)
  • Task/Activity
  • Notes (optional)

Formatting Your Timesheet

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 that you have the basic structure, let's make your timesheet more user-friendly and visually appealing.

To change the font, click on the 'Home' tab in the ribbon, then click on the font style and size you prefer. To change the fill color of the cells, click on the 'Fill Color' icon (a paint can) and select a color. You can also adjust the width of the columns by hovering over the line between two columns until the double-sided arrow appears, then drag it to your desired width.

Entering and Calculating Time Data

Elapsed Time Excel
Elapsed Time Excel

Now that your timesheet is set up, let's learn how to enter and calculate time data.

To enter start and end times, click on the cell where you want to enter the time, then click on the 'Home' tab in the ribbon. Click on the 'Number' group, then click on the 'Time' icon (a clock). This will allow you to enter time in the 24-hour format.

FREE Excel Timesheet Template [DOWNLOAD]
FREE Excel Timesheet Template [DOWNLOAD]
Excel - how to create timesheets
Excel - how to create timesheets
Add Time enter for Timesheet
Add Time enter for Timesheet
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)
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
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
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
the excel time and date sheet
the excel time and date sheet
Download Multiple Employees Weekly Timesheet Excel Template - ExcelDataPro
Download Multiple Employees Weekly Timesheet Excel Template - ExcelDataPro
Part 1: Create a Basic Excel Timesheet
Part 1: Create a Basic Excel Timesheet
How to Calculate Time in Excel / Add Time, Subtract Time Excel - Tutorial ⏰
How to Calculate Time in Excel / Add Time, Subtract Time Excel - Tutorial ⏰
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
Work Timesheet Excel | Templates at allbusinesstemplates.com
Work Timesheet Excel | Templates at allbusinesstemplates.com
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
Daily Work Tracker Excel: Essential Functions for Better Planning
Daily Work Tracker Excel: Essential Functions for Better Planning
Excel Timesheet Calculator
Excel Timesheet Calculator
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
Timesheet Hours in Excel
Timesheet Hours in Excel

Calculating Duration

To calculate the duration, we'll use a simple formula. In the cell where you want the duration to appear, enter the following formula: `=ENDTIME - STARTTIME`. This will automatically calculate the duration based on the start and end times you enter. Make sure to format this cell as time as well.

Using AutoFilter for Easy Navigation

To make navigating your timesheet easier, let's add an AutoFilter. Right-click on the header row of your table and select 'Filter' from the context menu. This will add drop-down menus to each column header, allowing you to filter the data by each column.

And there you have it! You've created a functional timesheet in Excel. Regularly updating your timesheet will help you stay on top of your hours and provide valuable data for billing and project management.

Remember, consistency is key when it comes to time tracking. Make it a habit to update your timesheet daily to ensure accurate records. Happy tracking!