Difference between dates/times in Days & Hours

  • Thread starter Thread starter Steve Vincent
  • Start date Start date
S

Steve Vincent

Hi,

I need to calculate the difference between two dates/times. The date/time
is entered in this format:

12/12/07 3:52 PM

When I simply subtract the end date from the start date, it gives me a
number in days with two-digit decimal place for partial day (e.g., 5.01). Is
there a way to format the cell or add to my simple formula (=B2-A2) to
convert the number into days/hours/minutes of some kind? I've been
experimenting without much luck, and didn't see a posting that was specific
to this issue.

Thank you in advance,
Steve
 
Steve,

How about this:

=DAY(B2-A2) & " Days " & HOUR(B2-A2) & " Hours " & MINUTE(B2-A2) & " Minutes
" & SECOND(B2-A2) & " Seconds"

Will that work for you?

HTH,

Conan
 
Back
Top