Displaying durations in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Verbatim - 20 Oct 2004 22:25 GMT

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.

Reply to this Message

Trevor Shuttleworth - 20 Oct 2004 22:44 GMT

Try Custom format: [hh]:mm:ss

Regards

Trevor

>I have a worksheet which calculates a duration in hours...is there a
>built-in
[quoted text clipped - 3 lines]
> All the built-in "time" formatters seem to be stuck on telling the time of
> day.

Reply to this Message

Verbatim - 21 Oct 2004 18:15 GMT

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
>
[quoted text clipped - 9 lines]
> > All the built-in "time" formatters seem to be stuck on telling the time of
> > day.

Reply to this Message