SECOND

Returns the second component [0…59] of the specified time.

Syntax

SECOND( Time time ) → Integer

Parameters

time

Required. The time that contains the minute.

Remarks

Time values are a part of date values and are represented by decimal numbers. For example, 12:00 PM is represented by 0.5 because it is exactly halfway through a day.

Example

Formula

=SECOND(NOW())

See Also

Function Reference
DAY Function
HOUR Function
MONTH Function
NOW Function
MINUTE Function
WEEKDAY Function