Question: how to calculate days between two dates and times 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.