Second Function

Returns a number between 0 and 59 representing the second of the minute of the specified time parameter.

Second (Time)

Parameters

Time  -  (Input, expression, Optional)

The time value to extract the seconds value from. If time is specified as a string expression, Newlook will convert it into a time as long as the string is in the form “hh:nn:ss” (it may also include a valid date, e.g. “Feb 1, 1999 10:30:00”). 

Return Value

An integer between 0 and 59, or Error if time is not a valid time.

Examples

Second (“11:22:33”)

Returns 33

Second (“Feb 1, 1999 11:22:33”)

Returns 33

Second (Now ())

Returns the current second.

Second (Null)

Returns Error

Second (Error)

Returns Error

TIP:

Functions are specifically for use in the Macro Editor. Refer to Microsoft's official VB and JScript documentation for scripting equivalents.

See Also

Date function | DateAdd function | DateDiff function | Day function | Hour function | Minute function | Month function | Now function | Second function | Time function | Week function | WeekDay function | Year function

© 2004-2021 looksoftware. All rights reserved.