Mastering Excel: Create Timesheets with Formulas

Gregory Jul 09, 2026

Time tracking is a crucial aspect of project management and productivity. Excel, with its powerful features, is an excellent tool for creating timesheets. In this guide, we'll walk you through the process of creating a timesheet in Excel using formulas.

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

Before we dive in, ensure you have a basic understanding of Excel and its formulas. We'll be using simple formulas like SUM, IF, and TEXT to create our timesheet. 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 Your Timesheet

First, let's set up the basic structure of our timesheet. We'll need columns for the date, project, hours worked, and a place to calculate the total hours.

how to create a time sheet in excel
how to create a time sheet in excel

Here's a simple layout to start with:

DateProjectHours WorkedTotal Hours
1Project A8
2Project B6
3Project A7
Excel Timesheet Calculator
Excel Timesheet Calculator

Calculating Total Hours

To calculate the total hours, we'll use the SUM function. In cell D2, enter the following formula:

=SUM(B2:C2)

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

This formula adds the hours worked in cells B2 and C2. Drag this formula down to copy it for the rest of the rows.

Formatting Dates

To display dates in a readable format, we'll use the TEXT function. In cell A2, enter the following formula:

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

=TEXT(A2,"dd/mm/yyyy")

This formula displays the date in the dd/mm/yyyy format. Drag this formula down to copy it for the rest of the rows.

Time Sheet Calculator in Excel
Time Sheet Calculator in Excel
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)
Part 1: Create a Basic Excel Timesheet
Part 1: Create a Basic Excel Timesheet
Timesheet Automation: Excel 24hr Creation
Timesheet Automation: Excel 24hr Creation
How to Calculate Over Time in Excel 🔥#excel #shortsvideo #exceltips #tipsntricks #exceltutorial
How to Calculate Over Time in Excel 🔥#excel #shortsvideo #exceltips #tipsntricks #exceltutorial
Elapsed Time Excel
Elapsed Time Excel
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
How to Calculate Hours Worked and Overtime Using Excel Formula - ExcelDemy
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 Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
How to Make an Availability Schedule in Excel (with Easy Steps) - ExcelDemy
EVERYTHING about working with Dates & Time in Excel
EVERYTHING about working with Dates & Time in Excel
a screenshot of the workdays formula in excel
a screenshot of the workdays formula in excel
Top 21 Excel Formulas
Top 21 Excel Formulas
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
3 Crazy Microsoft Excel Formulas That Are Extremely Useful
3 Crazy Microsoft Excel Formulas That Are Extremely Useful
How to use frequency formula in excel
How to use frequency formula in excel
How to Copy a Formula Down in Excel Using the Fill Handle
How to Copy a Formula Down in Excel Using the Fill Handle
Daily Work Tracker Excel: Essential Functions for Better Planning
Daily Work Tracker Excel: Essential Functions for Better Planning
how to calculate hours worked
how to calculate hours worked

Tracking Projects

Now, let's make our timesheet more dynamic. We'll create a dropdown list for projects and use a formula to display the total hours for each project.

Creating a Dropdown List

In cell B2, click the dropdown arrow that appears when you hover over the cell. Select 'Data Validation' and under 'Settings', choose 'List'. In the 'Source' field, enter the following:

={"Project A", "Project B", "Project C"}

This creates a dropdown list with three projects. You can add or remove projects as needed.

Calculating Project Totals

To calculate the total hours for each project, we'll use the SUMIF function. In a new sheet, enter the following formula:

=SUMIF(Timesheet!B$2:B$10, A2, Timesheet!C$2:C$10)

This formula adds up the hours worked for the project in cell A2. Replace 'Timesheet' with the name of your timesheet sheet.

And there you have it! You've created a dynamic timesheet in Excel using formulas. This timesheet allows you to track your hours, calculate totals, and even compare projects.

Remember, the key to effective time tracking is consistency. Make it a habit to fill out your timesheet daily. This will not only help you stay productive but also provide valuable data for future planning.