Calculate the Difference Between Time Greater than 24 Hours in Excel

Add to Favorites

Ill show you how to calculate the difference between two times in Excel when that difference will add up to more than 24 hours of time.

This is very similar to the tutorial on summing time greater than 24 hours here on

Here is an example of the problem with the wrong and right output displayed:

To solve the problem, we simply need to format the output cell as [h]:mm:ss  Thats it!

The Time(wrong) and Time(right) cells have the exact same formula:

The ONLY difference is the formatting for the cell.

To get the correct formatting, do this:

Right-click desired cell > Format Cells > Number tab > Custom category > [h]:mm:ss


Its almost annoying how simple this is when you think about all of the hours wasted on trying to figure this out.  Once again, time is a real pain in Excel, but its worth it to master it.

Dont forget to download the spreadsheet for this tutorial so you can better learn how to work with time in Excel!


Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Excel Time - Summing Time Greater than 24 Hours
Tutorial: I'll show you the easy and simple way to sum time past 24 hours in Excel.  All we really ...
Calculate the Difference Between Two Times in Excel
Tutorial: Here, youll learn how to get the difference between two times in Excel. A common example...
Absolute and Relative Cell References in Excel
Tutorial: In this tutorial I am going to cover the difference between Absolute and Relative Cell Ref...
Calculate the Total Time Worked Minus Lunch Breaks in Excel
Tutorial: Ill show you how to use Excel to calculate the total time worked in a day minus lunch tim...
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...
Filter Data to Show the Bottom 10 Percent of a Data Set in Excel - AutoFilter
Macro: This free Excel macro filters a data set to display the bottom 10 percent of the data set ...