Time format

[Guest]

Hi,

I've a number of seconds that appears like this: 759874 i need to format
it to appear like this h:mm:ss how can i do this?

 

[Roger Govier]

Hi Pietro

Divide the value by 86400 (24 hours x 60 mins x60 secs)
Format the cell with the formula as Custom dd:hh:mm:ss
to show days hours minutes and seconds.
You value results in 8:19:04:34

 

[David Biddulph]

=A18/24/3600 and format as [h]:mm:ss
Comes out as 211:04:34

 

[Guest]

=A1/86400