HoursBetween Function

Description:

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

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

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

Returns:

Whole Number

Parameters:

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

Examples:

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

{HoursBetween(OpeningTime, ClosingTime)}

Expression	Result
HoursBetween( Time(11,15,45), Time(23,15,45) )	12
HoursBetween( Time(11,15,45), Time(23,0,0) )	11

This article applies to: