View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hookette Hookette is offline
external usenet poster
 
Posts: 5
Default Formula for elapsed time

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