Converting Seconds to hh:mm:ss

[Mudbutt]

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.

 

[BenMiller]

Try =A3/86400 and format as hh:mm:ss

 

[Oeldere]

Try a3/(60*60*24) and format as [h]:mm:ss