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 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.