MinutesBetween Function

Description:

The number of whole minutes between a start time and a finish time.

If the start time is before the finish time then the minutes between is a positive number.

If the start time is after the finish time then the minutes between is a negative number.

Returns:

Whole Number

Parameters:

Parameter	Data Type	Description
1	Time	The start time.
2	Time	The finish time.

Example:

When using functions inside a field, remember the field brackets:

{MinutesBetween(StartBreakTime, FinishBreakTime)}

Expression	Result
MinutesBetween( Time(22,45,45), Time(23,15,45) )	30

This article applies to: