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)
Time (15.25; 0; 0 )
Time (22; 70; 70 )
Time (12; -30; 0)
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
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