This will get it to hours, minutes, and seconds.
=TEXT(ROUNDDOWN(A1/3600,0),"00") & ":" &TEXT(ROUNDDOWN(MOD(A1,3600)/60,0),"00") & ":"&TEXT(MOD(A1,60),"00")
This assumes your list starts in cell A1, then just copy down.
To get rid of leading zeros, you could add an if function, but it becomes complicated:
=IF(A1<60,":"&TEXT(MOD(A1,60),"00"),IF(A1<3600,TEXT(ROUNDDOWN(MOD(A1,3600)/60,0),"00")&":"&TEXT(MOD(A1,60),"00"),TEXT(ROUNDDOWN(A1/3600,0),"00")&":"&TEXT(ROUNDDOWN(MOD(A1,3600)/60,0),"00")&":"&TEXT(MOD(A1,60),"00")))
Bookmarks