You are here: Function Reference > Alphabetical Listing > S > Second

Second

Use this function to extract the number of seconds in a time.

Second (Time, Format)

Parameter	Description
Time	Enter a valid time string. The system assumes your entry is in the time format specified in the Format parameter. The default is the current time.
Format	Enter a valid time format string that describes the Time parameter. The default is time format 1 (HH:MM:SS).

Here are some examples:

(Assume the current time is 03:05:09.)

Function	Result	Explanation
Second( )	09	Defaults to the current time and extracts 09.
Second ("09:20:20")	20	Reads the given time and extracts 20.

Function

Result

Explanation

Second( )

Defaults to the current time and extracts 09.

Second

("09:20:20")

Reads the given time and extracts 20.