Count the Number of Whole Minutes between Two Times

To count the number of whole minutes between two times, you use the Minute Difference function with date and time inputs.

The Minute Difference function returns the number of whole minutes between two datetimes. This calculation includes only one endpoint.

For example:

the number of minutes late the train is = MinuteDifference(the time the train was scheduled to arrive, the time that the train actually arrived)

If the time the train was scheduled to arrive is 2019-10-18 08:30:00 and the time that the train actually arrived is 2019-10-18 09:00:40, then the number of minutes late the train is is 30.

Note: The order of the two datetimes in the function does not affect the result.