Formula for elapsed time

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
 
J

Jacob Skaria

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
 
H

Hookette

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top