Calculate the number of hours in a date/time cell
 

Morning,

I created a pivot table showing the sum of handover delays. If there were a
total 11hrs 40-mins delayed in a week then it correctly returns 11:40:00,
however, if delays exceed 24-hours (i.e. 25hrs and 32-mins) then the cell
displays 01:32:00 and when you select the cell it then shows 01/01/1900
01:32:00.

What I would like to calculate is the total number of hours delayed, and not
the number of days and hours. Is there any way of doing this?

Many thanks

Calculate the number of hours in a date/time cell
 

Custom Format the cells to [h]:mm:ss to display the total time.

If this post helps click Yes
---------------
Jacob Skaria


"richardwo" wrote:

Morning,

I created a pivot table showing the sum of handover delays. If there were a
total 11hrs 40-mins delayed in a week then it correctly returns 11:40:00,
however, if delays exceed 24-hours (i.e. 25hrs and 32-mins) then the cell
displays 01:32:00 and when you select the cell it then shows 01/01/1900
01:32:00.

What I would like to calculate is the total number of hours delayed, and not
the number of days and hours. Is there any way of doing this?

Many thanks