Converting from Seconds Into HH:MM:SS Format

[ricardo1023]

I need to populate a column with the format hh:mm:ss. I received the input data for the column in seconds. For example if I have 368 seconds I need to populate the column with 00:06:08 Do you know how could I do this?

Thank you

 

[AnotherHiggins]

It's important to understand how Microsoft applications deal with time, so read faq68-5827

To answer your question - Divide by the number of seconds in a minute, by the number of minutes in an hour, by the number of hours in a day.

368/60/60/24 = 368/86400 = 0.004259259. Formated as hh:mm:ss, this will display 00:06:08.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

faq68-5827

Convert SECONDS to DAYS...
[tt]
=A1/60/60/24
[/tt]
Format as TIME

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Golom]

For another variation

Format(TimeSerial(0,0,368),"hh:nn:ss")