Calculate the number of hours in a date/time cell

  • Thread starter Thread starter richardwo
  • Start date Start date
R

richardwo

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
 
Custom Format the cells to [h]:mm:ss to display the total time.

If this post helps click Yes
 
Back
Top