Difference between hours greater than 24 hours excel

Navigation
5

How to calculate difference between hours in Excel when it exceeds 24h?

Example: 

A1 = 05/01/2016 11:40:53
B2 = 06/01/2016 12:29:53

B2-A1 = 24h:49min

However, it returns 00:49

    
asked by anonymous 19.04.2016 / 22:50

1 answer

9

It is a problem in formatting the cell that is storing the result.

If you leave the formatting as "number" the cell will display 1,03403 (depending on the number of decimal places you asked to display). If you leave the formatting as "date and time" a possible result will be 1/1/00 0:49 , already within the format options of type "hour" you can only consider the difference in time or take into account also the difference of days. >

You are choosing this option:

Choosethis:

    
19.04.2016 / 23:05
What is the best way to create accessible methods for any activity? Dynamic display of required, optional, or non-existent fields