how to calculate time in excel

How to Calculate Time in Excel

1. Subtract Time:

To find the difference between two times:

=B2 - A2

If A2 = 8:00 AM and B2 = 4:30 PM, result is 8:30 hours.

2. Format Time Cells:

Click here to get the best Discount on Hostinger Hosting Plans.

Use custom formatting to show hours and minutes:

[h]:mm

This allows total hours beyond 24 (e.g. 30:15 for 30 hours, 15 minutes).

3. Add Hours to Time:

To add 3 hours to a time in A2:

=A2 + TIME(3,0,0)

4. Convert Time to Decimal Hours:

To convert a time like 2:30 to 2.5:

=HOUR(A2) + MINUTE(A2)/60

5. Calculate Work Hours with Breaks:

If A2 = start, B2 = end, C2 = break time:

=(B2 - A2) - C2

Note:

Excel stores time as a fraction of a day. For example, 0.5 = 12:00 PM.

⏱️ How to Calculate Time in Excel

Introduction

Master time calculations in Excel and take control of your productivity, payroll, and project tracking.
Whether you’re managing employee timesheets, tracking project durations, or analyzing time-based data, Excel makes it easy to calculate time differences, add or subtract hours, and format time correctly with built-in functions.

Why Learn Time Calculation in Excel?

Working with time in Excel can be powerful—but tricky. Understanding the right formulas and formats allows you to accurately calculate hours worked, estimate deadlines, and keep track of time-based metrics in your personal or professional workflows.

Common Time Calculation Use Cases

🕒 Employee Timesheets – Calculate hours worked from clock-in and clock-out times
📆 Project Timelines – Track task durations and forecast completions
🚚 Logistics & Delivery – Measure transit and turnaround times
📊 Data Analysis – Compare time stamps, durations, or trends over time
📚 Study & Productivity Logs – Monitor how long tasks or sessions take

Key Excel Time Functions & Formats

=EndTime - StartTime – Basic formula to get time worked (e.g., =B2-A2)
=TEXT(time, "h:mm") – Format time values in hours and minutes
=NOW() – Current date and time
=HOUR(), =MINUTE(), =SECOND() – Extract specific time components
=TIME(h, m, s) – Create time manually
=[Hours] / 24 – Convert hours into Excel’s time format (as Excel stores time as a fraction of 24 hours)

📝 Pro Tip: Always format your cells as “Time” or “Custom (h:mm)” to ensure your results display correctly.

Time-Saving Tip

Need to calculate total hours worked, even across midnight? Excel handles it well if formatted right. Use [h]:mm in cell formatting to add up hours correctly—even beyond 24 hours.

Work Smarter with Time in Excel

From payroll to productivity, Excel offers everything you need to manage and analyze time with precision. With a few essential formulas and formatting tricks, you’ll streamline your work and gain better insights—hour by hour.

📌 Start calculating time in Excel today and make every minute count!