Convert Seconds to HH:MM:SS ???

Garvey

New Member
Joined
Jun 13, 2003
Messages
3
:rolleyes: :cry: :oops:

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.

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

It just seems I am :oops: ....
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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)
 
Upvote 0
Try:

=A1/86400

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

Hope this helps!
 
Upvote 0
:biggrin: :) :LOL:

Thank you all,

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

This site this best! Three cheers for your guys, Hip :LOL: Hip :LOL:
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,947
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top