Hour
Purpose
Returns a number representing the hour portion (0-23) of a specified time.
Format
Hour(time)
Parameters
time - any time value or
field of type time
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
Examples
Hour(“12:15:23”) returns 12.
Hour(Duration) + (Minute(Duration)/60) returns 2.5, when the Duration time field contains 2:30:15.
If(Hour(HoursWorked) > 8;“Overtime Pay”;“ “) returns Overtime Pay when the number of hours in HoursWorked is greater than 8.
Hour(CheckIn) returns 3 when the value of CheckIn is 3:24.
Related topics