In this article we will learn about how to Calculate Number of Minutes between Dates and Time in Microsoft Excel 2010.
To calculate the number of minutes between two dates and times follow the below given steps.
We have two dates with time, 1st date in cell A1 and 2nd date in cellA2.
This value returned is the difference between two dates in terms of the number of minutes between the two. This number can then be used for other calculations.
Calculate time difference between Date and Today
To calculate number of days, months or years between two dates, we will use Datedif Function.
Column A contains Dates & in column B we want to see the Result.
See example 1 below -
Datedif function is used to calculate the interval between two dates in days, months or years.
Syntax =DATEDIF(start_date, end_date, interval_unit)
The Datedif function has 3 arguments:
In example 1, considering that the date the file was created was 9th July 2014, the number of days between 9th June 2014 and the file created date is 30 days which is returned in cell B5 above. Similarly, the other values are calculated. Instead of entering the current date / file created date, today() is entered which will keep changing as the date changes.
In the below screenshot, we have Start Date, End Date & Interval Unit in column A, B & C respectively. The result will be returned in column D.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.