Returns the number of seconds that have elapsed on your computer's system clock since midnight.

Syntax

SECONDS( )

Description

SECONDS( ) returns the number of seconds to the hundredth of a second that have elapsed on your system clock since midnight (12 am). There are 86,400 seconds in a day, so the maximum value SECONDS( ) can return is 86,399.99, just before midnight.

Use SECONDS( ) to calculate the amount of time that portions of your program take to run. SECONDS( ) is more convenient for this purpose than TIME( ) because SECONDS( ) returns a number rather than a character string.

You can also use SECONDS( ) instead of ELAPSED( ) to determine elapsed time for the current day to within hundredths of a second.