Having to calculate date and time difference in Excel is a common task. Unfortunately, depending on your requirements it is also not always a simple one.
Take this example where column A contains a start date and time, and column B an end date and time. We wish to calculate the elapsed time in days, hours and minutes e.g. 11 days 4 hours 9 minutes.
There are multiple ways of calculating date and time difference in Excel. In this scenario we will need to get a little clever.
As you may well know, date and time values are stored as numbers in Excel. For example, the 05/01/2017 10:10 is stored as 42740.42.
Therefore, if I write the formula as =B2-A2, then the result is returned as 2.993056.
To return a result that makes sense to us, we will tackle the date and time parts of the cell separately. Continue reading