Reference > Functions reference > Time functions > Hour
 
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