Seconds into HH:MM:SS

  • Thread starter Thread starter mathewheys
  • Start date Start date
M

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
 
"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
Click to expand...

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.
 
Back
Top