Category: Time

Syntax: Seconds ( time )


timeAny valid time value or expression that returns a valid time value.

Data type returned: Number


The Seconds() function returns an integer representing the number of seconds specified by the time parameter.

This function always returns a value from 0 to 59.

If you want to express the output of this function as a two-character string rather than as an integer (for example, 03 rather than 3), use the following formula:

 Right ("00" & Seconds (Time); 2)

If the time parameter has a seconds value greater than 59, the Seconds() function returns the Mod-60 result of that value. For instance, Seconds ("12:42:87") returns 27. Note that the "overflow" of the seconds value is applied to the minutes value: Minute ("12:42:87") returns 43.




Seconds ("10:45:20")

Returns 20.

Seconds ("12:15 am")

Returns 0.

: 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 © 2008-2020.
If you may any questions please contact us: