Question: how to calculate number of days between two dates and time in excel?
Answer: =A2-TRUNC(A2) Subtracting one date from another will give the number of days between. When you subtract one date from another, Excel will typically format the formula cell as a date, too.