Convert real number to an h:mm:ss display

T

Tom Weyand

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.

--
 
F

Fred Smith

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.
 
Top