Note that negative numbers becomemore negative.
For example, while INT(10.8) returns 10, INT(-10.8) returns -11.
TEXT Function
The Excel TEXT function returns a number formatted as text.
in a text string with the number format of your choice.
Get days, hours, and minutes between dates
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 """)
