Duration of time for two dates in days, hours and minutes

**sgrimm** · 09-15-2006, 10:26 AM

I found from an online tool that calculated the duration between the two dates and time listed below to be 2 days, 3 hours and 43 minutes.
7/5/06 9:49
7/7/06 13:32

I would like to be able to enter the information about the date and time into Excel and have Excel perform the calculation without having to go to the website and perform the calculation.

Any information would be greatly appreciated

**Shadowmistress** · 09-15-2006, 12:02 PM

Ok, you said any information is appreciated and I know this is a bit sloppy for using 2 cells to calculate but here goes...

Cell A1= date 1
Cell A2= date 2
Cell A3= ABS(A1-A2)
Cell A4= CONCATENATE(TRUNC(TEXT(A3,"[h]")/24)," days, ",HOUR(A3)," hours ",MINUTE(A3)," minutes")

This will count days but not months or years.