Converting Seconds to HH:MM:SS

[Neenas19]

Hello ,
I currently have the amount of time in SECONDS and am looking for a way to convert it to HH:MM:SS. Either Excel or Access would work. Any ideas?

 

[xlbo]

Hi - try this
if time in seconds is in A1 then
=INT(A1/3600)&":"&INT((A1-(INT(A1/3600)*3600))/60)&":"&A1-((INT(A1/3600)*3600)+(INT((A1-(INT(A1/3600)*3600))/60)*60))
will give you hours mins and secs
HTH
Geoff

 

[GlennUK]

An easier formula is this ....

=TEXT(A1/(24*60*60),"[H]:MM:SS&quot

again assuming the time in seconds is in cell A1.

Glenn.

 

[Neenas19]

this worked beautifully. Thank you both!