Time
Returns a time result with the specified number of hours, minutes, and seconds.
Format
Time ( hours ; minutes ; seconds )
Parameters
hours
- the hour value of a time
minutes
- the minutes value of a time
seconds
- the seconds value of a time
Data type returned
time
Originated in version
6.0 or earlier
Description
FileMaker Pro compensates when you supply fractional hours or minutes. The result is the time, formatted according to the time format of the field in the current layout.
Use the Time function or the GetAsTime function to enter a time constant into a formula.
Example 1
Time(4;14;32)
returns 4:14:32.
Time(4.5;10;30)
returns 4:40:30.
Time(4;15;70)
returns 4:16:10.