Seconds into HH:MM:SS

[mathewheys]

Hi

I am trying to covert Seconds in total hrs: Min: sec
in cell a1 = 142195 cell b2 = time(,,a1) this is returning a #NUM!
error
I have also tryed to look change the formate of the cell to [H]:MM:SS
this has also not worked

Please help

 

[Alan]

"mathewheys"
<[email protected]>
wrote in message

Hi

I am trying to covert Seconds in total hrs: Min: sec
in cell a1 = 142195 cell b2 = time(,,a1) this is returning a #NUM!
error
I have also tryed to look change the formate of the cell to
[H]:MM:SS this has also not worked

Please help


--
mathewheys
-----------------------------------------------------------------
mathewheys's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=25093
View this thread:
http://www.excelforum.com/showthread.php?threadid=390088

Hi,

To convert seconds into days (excel's standard unit of time), just
divide by 86,400 (24 x 60 x 60).

Then format the answer as you prefer (probably as per your post).

HTH,

Alan.