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

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

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.