SecondsBetween Function

Description:
The number of whole seconds between a start time and a finish time.
If the finish time is after the start time then the number of seconds between them will be positive.
If the finish time is before the start time then the number of seconds between them will be negative.
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:
{SecondsBetween(BankOpeningTime, BankClosingTime)}
Expression
Result
SecondsBetween( Time(23,15,45), Time(23,20,0) )
255

Related Content