# Thread: Convert Seconds to HH:MM:SS ??? Thanks: 0 Likes: 0

1. ## Convert Seconds to HH:MM:SS ???

Convert Seconds to HH:MM:SS Formula

Im trying to build this report at work but get all my times in seconds.
Like 10716 secs. I need to convert these in to HH:MM:SS format for easy reading and calculating the rest of my sheets.

I found a Macro on how to do it but I really need a formula to do this.

Im close to binning this report as I just cant figure it out. Please Please Me.

It just seems I am ....

2. ## Re: Convert Seconds to HH:MM:SS ???

since excel stores time as fractions of a day, divide your number by the number of seconds in a day (86,400) and format the formula cell to your liking (ie [h]:mm:ss)

3. ## Re: Convert Seconds to HH:MM:SS ???

=A1/86400

Custom format the formula cell as [hh]:mm:ss

4. Try:

=A1/86400

where A1 stores the number of seconds. Then format the cell with the custom format "hh:mm:ss."

Hope this helps!

5. ## Re: Convert Seconds to HH:MM:SS ???

Thank you all,

this works a treat . Ive just converted the seconds and thats spot on what I wanted.

This site this best! Three cheers for your guys, Hip Hip

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•