Displaying durations in Excel

[Verbatim]

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.

 

[Trevor Shuttleworth]

Try Custom format: [hh]:mm:ss

Regards

Trevor

 

[Verbatim]

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.

Try Custom format: [hh]:mm:ss

Regards

Trevor

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.