SECOND Function (VisioShapeSheet)

發行項
09/15/2015

Returns an integer, 0 to 59, that represents the seconds component of datetime or expression.

Syntax

SECOND("datetime"|expression[,lcid])

Parameters

Name	Required/Optional	Data Type	Description
datetime	Required	String	Any string commonly recognized as a date and time or a reference to a cell containing a date and time.
expression	Required	String	Any expression that yields a date and time.
lcid	Optional	Numeric	The locale identifier to be used in evaluating a nonlocal datetime. The locale identifier is a number described in the system header files.

Return Value

Integer

Remarks

The date component in datetime or expression is discarded.

No rounding is done. If datetime is missing or cannot be converted to a valid result, this function returns an error.

The SECOND function also accepts a single number value for expression where the decimal portion of the result represents the fraction of a day since midnight.

Example 1

SECOND("05/30/1997 13:45:32")

Returns 32.

Example 2

SECOND(TIMEVALUE("May 30, 1996 12:07:45") + 7 es.)

Returns 52.

Example 3

SECOND(0.6337)