Fortunately, Excel offers a built-in function, DATEDIF, which makes it easy to calculate elapsed calendar time.

Easy way to calculate time difference in Excel using simple logic. A simple formula to calculate difference between two dates & times in Excel.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.