Category: Time

Syntax: Time ( hours; minutes; seconds )


hoursA number representing the hours portion of the desired time value.

minutesA number representing the minutes portion of the desired time value.

secondsA number representing the seconds portion of the desired time value.

Data type returned: Time


Returns a time value built from the specified hours, minutes, and seconds parameters. The resulting value accurately calculates the effect of fractional parameters. Similarly, although the typical range for the minutes and seconds parameters is from 0 to 59, any values above or below are compensated for in the resulting time value.

The Time() function is often used in conjunction with the Hour(), Minute(), and Seconds() functions. For instance, the following formula takes the current time and returns the time of the next lowest hour:

 Time (Hour (Get (CurrentTime));0;0))




Time (8; 34; 15)

Returns 8:34:15.

Time (15.25; 0; 0 )

Returns 15:15:00.

Time (22; 70; 70 )

Returns 23:11:10.

Time (12; -30; 0)

Returns 11:30:00.

: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net