Displaying durations in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet which calculates a duration in hours...is there a built-in
number formatter that could display that as h:mm:ss? How would I create a
formatter to do that if there isn't?

All the built-in "time" formatters seem to be stuck on telling the time of
day.
 
Thanks, that does convert the numbers to durations...it interprets the
floating-point number as a number of days, so I had to add a "/24" to my
calculations, but now it's working.

Trevor Shuttleworth said:
Try Custom format: [hh]:mm:ss

Regards

Trevor


Verbatim said:
I have a worksheet which calculates a duration in hours...is there a
built-in
number formatter that could display that as h:mm:ss? How would I create a
formatter to do that if there isn't?

All the built-in "time" formatters seem to be stuck on telling the time of
day.
Click to expand...
Click to expand...
 
Back
Top