How to calculate difference between two dates and times in Excel
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-calculate-difference-between-two-dates-and-times-in-Excel.png)
Excel offers a very interesting way to calculate the difference between two dates and times. We can cater to this problem statement by using the “-” operator. We can perform the below mentioned way to calculate difference between two dates and times in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel workbook with 2 dates and times
![](https://spreadcheaters.com/wp-content/uploads/Step-1-How-to-calculate-difference-between-two-dates-and-times-in-Excel.png)
– Open the desired Excel workbook which contains 2 dates and times in different cells
Step 2 – Subtraction of the cells
![](https://spreadcheaters.com/wp-content/uploads/Step-2-How-to-calculate-difference-between-two-dates-and-times-in-Excel.png)
– Now subtract the 2 cells to get the difference between them in number of days
Step 3 – Difference obtained
![](https://spreadcheaters.com/wp-content/uploads/Step-3-How-to-calculate-difference-between-two-dates-and-times-in-Excel.png)
– We can see that the difference between the 2 dates and times have been calculated in the number of days..