Converting Seconds to hh:mm:ss

Mudbutt

Board Regular
Joined
Jul 18, 2011
Messages
158
I have a formatting issue I can't figure out. I have the amount of time a machine is up logged in seconds in my cells. However, I want to convert that to a format that makes more sense like hh:mm:ss. However, just simply formatting the cell in that format is not exactly doing the trick because it doesn't know that the value in the cell is logged in seconds. Does anyone have a solution here?

I'm using Excel 2003, as an example I have in A1 my machine name, A2 the date, and A3 the amount of seconds it was running, in this case 47894.
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

BenMiller

Well-known Member
Joined
Nov 17, 2011
Messages
1,961
Office Version
  1. 365
Platform
  1. Windows
Try =A3/86400 and format as hh:mm:ss
 

Oeldere

Well-known Member
Joined
Dec 29, 2011
Messages
2,213
Try a3/(60*60*24) and format as [h]:mm:ss
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,123,489
Messages
5,601,982
Members
414,489
Latest member
Xlambda

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
Top