i need to convert seconds (ie: 17288.35111) into days, hours, min
 

i am trying to create a forumula that takes various numbers and tells me how
many seconds it will take to do something. I would like to take the resulting
seconds and convert to a Day, Hour, Minute, Second format.

jr,

If the sum is in cell A10, then

=INT(A10/86400) & " Day(s), and " &TEXT(A10/86400-INT(A10/86400),"hh:mm:ss")

HTH,
Bernie
MS Excel MVP


"jriechers" wrote in message
...
i am trying to create a forumula that takes various numbers and tells me
how
many seconds it will take to do something. I would like to take the
resulting
seconds and convert to a Day, Hour, Minute, Second format.