Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
Chapter 14
|
Time functions 203
Seconds
Format
Seconds(time)
Parameter
time - any time value or
of type time
Data type returned
number
Description
Returns a number representing the number of seconds in time.
Examples
Seconds(“12:15:23”) returns
23
.
Hour(Duration) + (Minute(Duration)/60) + (Seconds(Duration)/3600
returns
2.504166
, if the Duration time field contains 2:30:15.
Time
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
minutes - the minutes value of a time
seconds - the seconds value of a time
Data type returned
time
Description
Returns a time result with the specified number of hours, minutes, and seconds.
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
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
into a
.