Filemaker Pro 8.5 Advanced Maintenance TG761Z/A User Manual
Product codes
TG761Z/A
202 FileMaker Functions Reference
Hour
Format
Hour(time)
Parameter
time - any time value or
of type time
Data type returned
number
Description
Returns a number representing the number of hours in time.
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.
Minute
Format
Minute(time)
Parameter
time - any time value or
of type time
Data type returned
number
Description
Returns a number representing the number of minutes in time.
Examples
Minute(“12:15:23”) returns
15
.
Hour(Duration) + (Minute(Duration)/60) returns
2.5
, if the Duration time field
contains 2:30:15.