Formula for elapsed time

  • Thread starter Thread starter Hookette
  • Start date Start date
H

Hookette

I have two cells with dates and time in them and I need to figure out elapsed
time. When it's within the same month C2-B2 works fine, if it's months apart
my formula doesn't work.

I have:
C2 has: 7/10/09 10:40
B2 has: 3/25/08 13:02
so I need how many months, days, hour and mins elapsed.

I also have:
C2: 7/6/09 10:26
B2: 3/29/09 23:06
so I need how many months, days hour and mins elapsed. (when I do this I
get 4 months instead of 3 months and 7 days, 11 hours and 20 mins).
thanks
 
Try

=DATEDIF(B2,C2,"m") & " months " & DATEDIF(B2,C2,"md") & " days " &
TEXT(C2-B2,"hh") & " hours " & LEFT(TEXT(C2-B2,"mm:ss"),2) & " minutes"

If this post helps click Yes
 
Any way, once you get all the months, days, hours, etc., that you can get an
average of it all? Using the Avg function doesn't work.

Thanks.
 
Back
Top