Reference > Functions reference > Time functions > Time
 

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 

FileMaker Pro 6.0 or earlier

Description 

FileMaker Pro Advanced 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.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas