Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Elapsed Time Formula | Excel Worksheet Functions | |||
formula to add time elapsed | Excel Worksheet Functions | |||
Formula for elapsed time + grand total | Excel Discussion (Misc queries) | |||
time elapsed formula | Excel Worksheet Functions | |||
Ref: Formula to calculate elapsed time between certain dates and t | Excel Discussion (Misc queries) |