Elapsed time between two dates

**bmunoz64** · 03-20-2012, 05:53 PM

I have a date and time in one cell and another date and time in another. How do I calculate the elapsed time in days and hours?

Example:
A1 = 3/10 6 pm
B1 = 3/16 4 pm
C1 = difference in number of days and hours from B1-A1

**Dennis7849** · 03-20-2012, 05:57 PM

Simple stuff.

Just format all these cells as "mm/dd/yyyy hh:mm:ss".
If A1 has the start time and B1 has the end time,
then the formula is =B1-A1

**daddylonglegs** · 03-20-2012, 05:57 PM

Try this formula in C1

=INT(B1-A1)&" days "&TEXT(B1-A1,"h:mm")

**DGagnon** · 03-20-2012, 05:57 PM

that formula above shoudl work,

=B1-A1, then just format as custom format

Please Login or Register  to view this content.

or what ever format you would like to display it as.

**daddylonglegs** · 03-20-2012, 06:00 PM

Note that using d in formatting will only show days up to 31 so if time period could be longer than 31 days you need another method, hence my suggestion.