How to Track Time in Excel

Time tracking is important for understanding how working hours are spent, calculating payroll, managing projects, measuring productivity, and billing clients accurately. While there are many dedicated time-tracking tools available, Microsoft Excel remains a simple and flexible option for individuals, freelancers, and small teams.

With the right spreadsheet structure and a few Excel formulas, you can create a basic time tracker that records start and end times, calculates working hours, subtracts breaks, tracks overtime, and summarizes hours by employee or project.

The good news is that you do not need advanced Excel knowledge to get started.

In this guide, you will learn how to track time in Excel, which formulas to use, how to calculate hours and overtime, how to handle overnight shifts, and when you may want to move from Excel to dedicated time-tracking software.

What Is Time Tracking in Excel?

Time tracking in Excel means using a spreadsheet to record and calculate the amount of time spent working.

A basic Excel time tracker can record information such as:

• Date

• Employee name

• Project

• Task

• Start time

• End time

• Break duration

• Total working hours

• Overtime

• Billable status

• Hourly rate

For example, an employee could enter their start time as 9:00 AM and their end time as 5:30 PM. Excel can then calculate the difference automatically.

If the employee takes a one-hour lunch break, the spreadsheet can subtract that break and calculate 7.5 hours of actual working time.

This makes Excel useful for simple employee timesheets, freelance time tracking, project management, client billing, and personal productivity tracking.

Why Track Time in Excel?

Excel is popular for time tracking because it is familiar, flexible, and easy to customize.

Excel Is Easy to Customize

Unlike a fixed timesheet system, you can create an Excel spreadsheet around the exact information you need.

For example, a freelancer might track:

• Client

• Project

• Task

• Start time

• End time

• Billable hours

• Hourly rate

• Total amount

An employee timesheet might instead include:

• Employee

• Date

• Shift

• Clock-in

• Clock-out

• Break

• Regular hours

• Overtime

You can add or remove columns whenever your requirements change.

Excel Can Automate Calculations

You do not need to manually calculate every employee's working hours.

Excel formulas can automatically calculate:

• Daily working hours

• Weekly working hours

• Monthly working hours

• Break deductions

• Overtime

• Billable hours

• Project totals

• Employee totals

Once the formulas are set up, you only need to enter the relevant time information.

Excel Is Affordable and Accessible

Many people already have access to Excel through Microsoft 365 or their workplace.

That means you can create a basic time tracker without purchasing a separate time-tracking platform.

For a freelancer or small team with simple requirements, this can be enough.

How to Create a Time Tracker in Excel

The first step is to create a spreadsheet that contains the information you want to track.

A simple structure can include:

• Date

• Employee

• Project

• Task

• Start Time

• End Time

• Break

• Total Hours

For example, your spreadsheet could contain the following columns:

A: Date

B: Employee

C: Project

D: Task

E: Start Time

F: End Time

G: Break

H: Total Hours

You can add additional columns later for overtime, hourly rates, billable status, or notes.

Step 1: Enter the Date and Employee Information

Start by entering the date of the work session.

For example:

August 25, 2026

If you are tracking multiple employees, add the employee's name in the next column.

You can also create a dropdown list containing employee names using Excel's Data Validation feature.

This prevents employees from entering slightly different versions of their names.

For example, instead of having:

• John

• john

• John Smith

• J. Smith

you can provide a standardized employee list.

Step 2: Enter the Start and End Times

Next, enter the employee's starting and finishing times.

For example:

Start Time: 9:00 AM

End Time: 5:30 PM

Excel needs to recognize these values as time values rather than ordinary text.

Common formats include:

• 9:00 AM

• 9:30 AM

• 5:30 PM

• 17:30

Once Excel recognizes the values as times, you can use formulas to calculate the difference.

Step 3: Calculate Total Working Hours

Suppose the start time is in cell E2 and the end time is in cell F2.

Use this formula:

=F2-E2

This calculates the difference between the end time and start time.

For example:

• Start: 9:00 AM

• End: 5:30 PM

• Total: 8 hours 30 minutes

However, the result needs to be formatted correctly.

Select the result cell and change its number format to:

[h]:mm

The [h] format is particularly useful for time tracking because it allows Excel to display accumulated hours beyond 24 hours.

Step 4: Subtract Break Time

If employees take unpaid breaks, you can subtract those breaks from the total working time.

Suppose:

• Start Time is E2

• End Time is F2

• Break is G2

Use:

=F2-E2-G2

For example:

• Start: 9:00 AM

• End: 5:30 PM

• Break: 1 hour

• Working time: 7 hours 30 minutes

This formula automatically removes the break from the total.

Make sure the break cell is also formatted as a time value.

Step 5: Convert Working Hours Into Decimal Hours

Sometimes you need hours in decimal form instead of hours and minutes.

For example:

• 7 hours 30 minutes = 7.5 hours

• 7 hours 15 minutes = 7.25 hours

• 8 hours 45 minutes = 8.75 hours

Decimal hours are particularly useful for payroll and client billing.

To convert your calculated time into decimal hours, multiply it by 24:

=(F2-E2-G2)*24

If the employee worked 7 hours and 30 minutes, Excel returns:

7.5

You can then multiply the decimal hours by an hourly rate.

For example:

=7.5*25

This calculates $187.50 at an hourly rate of $25.

How to Track Time for Multiple Employees

Excel can also be used as a basic employee timesheet.

Add an employee column and create one row for each work session.

For example, you might record:

• Employee name

• Date

• Start time

• End time

• Break

• Total hours

This allows you to filter your spreadsheet by employee.

You can also use Excel formulas to calculate how many hours each employee worked during a specific period.

The SUMIF function is useful for this.

For example:

=SUMIF(B:B,"Alex",H:H)

This adds the values in column H for rows where column B contains "Alex."

For more complex conditions, you can use SUMIFS.

This can be useful when you want to calculate hours for a specific employee, project, date range, or combination of criteria.

How to Track Time by Project in Excel

If you work on multiple projects, tracking time by project can help you understand where your team's hours are going.

Add a Project column to your spreadsheet.

You can then record:

• Date

• Employee

• Client

• Project

• Task

• Start time

• End time

• Break

• Total hours

For example, an employee might spend three hours on website development, two hours on testing, and one hour on a client meeting.

Once the information is recorded, you can calculate the total time spent on each project.

This is especially useful for agencies, freelancers, consultants, and software development teams.

Use SUMIFS to Calculate Project Hours

The SUMIFS function allows you to calculate hours based on multiple conditions.

For example, you could calculate all hours associated with a particular project while also filtering by employee.

This makes it possible to answer questions such as:

• How many hours did Alex spend on Project A?

• How much time did the development team spend on Client B?

• How many billable hours were recorded this month?

• How much time was spent on internal work?

This turns a simple timesheet into a basic project reporting system.

How to Track Billable Hours in Excel

Freelancers and service businesses often need to distinguish between billable and non-billable time.

For example, you may spend time on:

• Client development

• Client meetings

• Internal meetings

• Administration

• Marketing

• Training

Not all of these activities are necessarily billable.

Add a Billable column to your spreadsheet and use values such as:

• Yes

• No

You can then calculate your total billable hours using a formula such as:

=SUMIF(J:J,"Yes",H:H)

This adds the hours associated with rows marked as billable.

You can also add an hourly rate and calculate the amount to invoice.

For example:

=Billable_Hours*Hourly_Rate

This can make Excel useful for basic client billing.

How to Calculate Overtime in Excel

If employees work beyond their standard hours, Excel can calculate overtime automatically.

Suppose the standard working day is eight hours.

If the total working time is in H2, use:

=MAX(0,H2-TIME(8,0,0))

This calculates any time worked beyond eight hours.

For example:

• Total working time: 9 hours

• Standard hours: 8 hours

• Overtime: 1 hour

The MAX function prevents Excel from displaying a negative overtime value when an employee works fewer than eight hours.

If you need overtime as decimal hours, multiply the result by 24:

=MAX(0,H2-TIME(8,0,0))*24

You can also create separate columns for regular hours and overtime.

This makes payroll calculations easier to review.

How to Calculate Weekly Hours in Excel

Once you have daily working hours, calculating weekly totals is simple.

Suppose the daily hours are stored in H2 through H6.

Use:

=SUM(H2:H6)

This adds the working hours for the week.

If the cells contain time values, format the result as:

[h]:mm

This prevents Excel from resetting the display after 24 hours.

For example, an employee could work:

• Monday: 8 hours

• Tuesday: 8 hours

• Wednesday: 7.5 hours

• Thursday: 8 hours

• Friday: 7.5 hours

The weekly total would be:

39 hours

You can use the same approach to calculate monthly working hours.

How to Track Overnight Shifts in Excel

Overnight shifts create a common problem in Excel.

Suppose an employee starts work at:

10:00 PM

and finishes at:

6:00 AM

A basic formula such as:

=F2-E2

may produce an incorrect result because Excel treats 6:00 AM as earlier than 10:00 PM on the same day.

To calculate overnight hours correctly, use:

=MOD(F2-E2,1)

This allows Excel to calculate the duration across midnight.

For example:

• Start: 10:00 PM

• End: 6:00 AM

• Total: 8 hours

This formula is useful for businesses that operate overnight, including:

• Security companies

• Hospitals

• Customer support teams

• Restaurants

• Manufacturing companies

• Warehouses

• IT operations

How to Create a Weekly Timesheet in Excel

A weekly timesheet can make daily time tracking easier.

Create rows for each working day and columns for the information you need.

For example, track:

• Monday

• Tuesday

• Wednesday

• Thursday

• Friday

• Saturday

• Sunday

For each day, record:

• Start time

• End time

• Break

• Total hours

• Overtime

At the bottom of the sheet, calculate the weekly total using:

=SUM(E2:E8)

You can also add separate totals for:

• Regular hours

• Overtime

• Billable hours

• Non-billable hours

This gives you a basic weekly overview without requiring additional software.

How to Make Excel Time Tracking Easier

A basic spreadsheet works, but several Excel features can make your time tracker more reliable.

Use Data Validation

Data Validation can create dropdown menus for fields such as:

• Employee

• Project

• Task

• Billable status

• Work location

This reduces inconsistent data entry.

Use Conditional Formatting

Conditional formatting can automatically highlight unusual entries.

For example, you can highlight:

• More than eight hours worked

• Missing start times

• Missing end times

• Overtime

• Incomplete records

• Unusually long breaks

This makes errors easier to identify.

Use Excel Tables

Converting your time-tracking range into an Excel Table can make the spreadsheet easier to manage.

Tables automatically expand when you add new rows and can make formulas easier to copy.

They also make filtering and sorting your time records more convenient.

Protect Formula Cells

If multiple people use the spreadsheet, consider protecting cells that contain formulas.

This prevents users from accidentally replacing formulas with manually entered values.

It is especially useful for employee timesheets where workers should enter their hours but should not modify calculation formulas.

Common Excel Time-Tracking Mistakes

Excel can calculate time accurately, but the spreadsheet still depends on correct data entry.

Entering Time as Text

If Excel treats a time value as text, formulas may not work correctly.

Make sure your start and end times are recognized as actual Excel time values.

Using the Wrong Number Format

One of the most common mistakes is using a standard time format for accumulated hours.

For totals, use:

[h]:mm

This allows Excel to display totals greater than 24 hours.

Forgetting Breaks

If breaks are unpaid, make sure they are included in the calculation.

Otherwise, employees may appear to have worked more hours than they actually did.

Ignoring Overnight Shifts

If employees work across midnight, use the appropriate formula instead of simply subtracting the start time from the end time.

Manually Changing Calculated Hours

Once you have created formulas, avoid manually editing calculated values.

If the calculation is incorrect, fix the formula instead.

This keeps the spreadsheet consistent and reduces errors.

How to Track Time for Freelancers in Excel

Excel can be particularly useful for freelancers who need to track billable work.

A freelancer can create columns for:

• Date

• Client

• Project

• Task

• Start time

• End time

• Break

• Total hours

• Billable hours

• Hourly rate

• Amount

For example, a freelancer working at $50 per hour could track development, meetings, testing, and revisions throughout the week.

At the end of the week or month, they can calculate total billable hours and multiply them by the agreed hourly rate.

This creates a simple record that can also be used when preparing invoices.

How to Track Time for Remote Employees in Excel

Excel can also be used for remote employee timesheets.

Employees can enter their:

• Start time

• End time

• Breaks

• Tasks

• Projects

• Total hours

Managers can then review the submitted timesheets.

However, this approach relies heavily on employees entering accurate information.

Excel does not automatically know when someone starts working unless another system or automation is connected to the spreadsheet.

This is one of the biggest limitations of spreadsheet-based time tracking.

Is Excel Good for Employee Time Tracking?

Excel can be a good option for small teams with straightforward requirements.

It works particularly well when:

• You have a small number of employees.

• Employees have predictable schedules.

• You only need basic timesheets.

• You are comfortable maintaining formulas.

• You do not need real-time tracking.

• You do not need automated attendance.

• You do not need advanced payroll integrations.

For these situations, an Excel timesheet can be simple and cost-effective.

However, Excel becomes harder to manage as your team grows.

Excel vs Dedicated Time-Tracking Software

Excel is useful because it is flexible, but dedicated time-tracking software can automate many tasks that require manual work in a spreadsheet.

Excel Is Better When

• You only need basic time tracking.

• You are tracking your own work.

• You have a small team.

• You want complete control over your spreadsheet.

• Your reporting requirements are simple.

• You do not need real-time tracking.

• You are comfortable maintaining formulas.

Dedicated Time-Tracking Software Is Better When

• You manage a larger team.

• Employees frequently forget to submit timesheets.

• You need automatic timers.

• You need employee attendance tracking.

• You need shift scheduling.

• You need automated approvals.

• You need payroll integrations.

• You need real-time reporting.

• Employees work across different locations.

• You need mobile time tracking.

• You want to reduce manual data entry.

The key difference is automation.

With Excel, employees generally have to record their time manually.

With dedicated time-tracking software, many parts of the process can be automated.

When Should You Stop Using Excel for Time Tracking?

There is no specific number of employees at which you must stop using Excel.

The better question is whether the spreadsheet is still saving you time or creating more work.

You may want to consider dedicated time-tracking software when:

• Managers spend hours reviewing timesheets.

• Employees frequently submit incorrect hours.

• You have multiple spreadsheets for different teams.

• Payroll requires extensive manual calculations.

• You need real-time visibility into employee activity.

• You need automated attendance.

• You need detailed project profitability reports.

• You need integrations with other business systems.

• You need employees to track time from mobile devices.

• You need more reliable data than manual timesheets can provide.

When time tracking itself becomes an administrative burden, automation can become more valuable than spreadsheet flexibility.

Final Thoughts

Learning how to track time in Excel is relatively simple once you understand Excel's time calculations.

A basic spreadsheet can record start and end times, subtract breaks, calculate daily and weekly hours, track overtime, separate billable and non-billable work, and calculate project costs.

The most useful formulas to remember are:

=End_Time-Start_Time

for calculating elapsed time,

=End_Time-Start_Time-Break

for calculating working hours after breaks,

=MOD(End_Time-Start_Time,1)

for overnight shifts, and:

=(End_Time-Start_Time-Break)*24

when you need working hours in decimal format.

Excel is an excellent starting point for individuals, freelancers, and small teams that need a straightforward way to record working hours.

However, spreadsheets rely on manual data entry and maintenance. As teams become larger and time tracking becomes more complex, dedicated time-tracking software can reduce administrative work and provide features such as automated timers, attendance tracking, approvals, reporting, integrations, and centralized employee data.

For simple requirements, Excel can be all you need. For growing teams that need automation and real-time visibility, moving beyond spreadsheets can make time tracking significantly easier.

Track Time Without Excel

Still tracking employee hours manually in Excel? Tracko makes time tracking simpler.

Track work hours, manage tasks, monitor attendance, and keep your team's time records organized—all in one place. No spreadsheets, no manual calculations, no messy timesheets.

Start tracking time with Tracko today: [Try Tracko Free]