Coverting seconds into hr:min:sec
 

I woul like to find out how to convert seconds into hr:min:sec. For an
example I would like to take 3661 seconds and convert it into 1hr 1 min 1 sec.

Coverting seconds into hr:min:sec
 

divide by 86400 then format as h:mm:ss


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=525948

Coverting seconds into hr:min:sec
 

If A1 contains 3661 and B1 contains:
=A1/24/60/60 will display as: 0.042372685
if formatted as hh:mm:ss will display as: 01:01:01


--
Gary's Student


"jsturino" wrote:

I woul like to find out how to convert seconds into hr:min:sec. For an
example I would like to take 3661 seconds and convert it into 1hr 1 min 1 sec.

Coverting seconds into hr:min:sec
 

Or, if you absolutely have to have the "hr", "min", "sec" text in the
results, you could use this formula....it is a bit long but works.
=INT(A1/3600)&"hr "&INT(((A1/3600)-INT(A1/3600))*60)&"min
"&ROUND(((((A1/3600)-INT(A1/3600))*60)-INT((((A1/3600)-INT(A1/3600))*60)))*60,2)&"sec"
Where A1 holds the number you wish to convert

"jsturino" wrote:

I woul like to find out how to convert seconds into hr:min:sec. For an
example I would like to take 3661 seconds and convert it into 1hr 1 min 1 sec.