Calculating days & time left from start date/time to end date/time
=ROUND(A2-A1,0)&" days and "&TEXT(A2-A1,"h:mm:ss")
Or if it is less than one month, you can just subtract them (=A2-A1) and use
a custom format of
d "days and" h:mm
They both look like this
25 days and 1:20:27
|