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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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