This article applies to:

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