Displaying durations in Excel

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.

Try Custom format: [hh]:mm:ss

Regards

Trevor


"Verbatim" wrote in message
...
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" wrote:

Try Custom format: [hh]:mm:ss

Regards

Trevor


"Verbatim" wrote in message
...
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.