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

J

jriechers

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.
 
B

Bernie Deitrick

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
 
Top