Convert real number to an h:mm:ss display
 

Let's say I have a real number, i.e. 123456.789, that is in seconds and I
want to display it as 34:17:37. I kinda got lost trying to use
TEXT(TIME(etc.)). Maybe there is a better way.

--

Convert real number to an h:mm:ss display
 

Excel stores times as fractions of a day. So change your seconds into days with:

=a1/86400

Format the result as [h]:mm:ss so that it will display more than 24 hours.

--
Regards,
Fred


"Tom Weyand" wrote in message
...
Let's say I have a real number, i.e. 123456.789, that is in seconds and I want
to display it as 34:17:37. I kinda got lost trying to use TEXT(TIME(etc.)).
Maybe there is a better way.

--

Convert real number to an h:mm:ss display
 

Worked just fine, thanks