Get days, hours, and minutes between dates
Generic formula
=INT(end-start)&" days "&TEXT(end-start,"h"" hrs ""m"" mins """)
Related formulas
Get days, months, and years between dates
Calculate years between dates
Get months between dates
Explanation
To calculate and display the days, hours, and minutes between two dates, you can use the TEXT function with a little help from the INT function.
In the example shown, the formula in D5 is:
=INT(C5-B5)&" days "&TEXT(C5-B5,"h"" hrs ""m"" mins """)
How this formula works
Most of the work in this formula is done by the TEXT function, which applies a custom number format for hours and minutes to a value created by subtracting the start date from the end date.
TEXT(C5-B5,"h"" hrs ""m"" mins """)
This is an example of embedding text into a custom number format, and this text must be surrounded by an extra pair of double quotes.
The value for days is calculated with the INT function, which simply strips off the integer portion of the end date minus the start date:
INT(C5-B5)
Although you can use "d" in a custom number format for days, the value will "roll over" back to zero when days is greater than 31.
Include seconds
To include seconds, you can extend the custom number format like this:
=INT(C5-B5)&" days "&TEXT(C5-B5,"h"" hrs ""m"" mins ""s"" secs""")