Hour

Returns a number representing the hour portion (0 to 23) of a specified time.

Format 

Parameters 

time - any time value or field of type time

Data type returned 

number

Originated in 

FileMaker Pro 6.0 or earlier

Example 1 

Hour ( "12:15:23" ) returns 12.

Example 2 

Hour ( CheckIn ) returns 3 when the value of CheckIn is 3:24.

Example 3 

Hour ( Duration ) + ( Minute ( Duration ) / 60 ) returns 2.5, when the Duration time field contains 2:30:15.

Example 4 

If ( Hour ( HoursWorked ) > 8 ; "Overtime Pay" ; " " ) returns Overtime Pay when the number of hours in HoursWorked is greater than 8.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas