Skip to main content
Version: Streamsheets 2.4

SECOND

Returns the second of the date value.

Syntax

=SECOND(DateValue[,Round])

Arguments

NameDescription
DateValueInsert a valid timestamp format or a cell reference to a timestamp. A timestamp consists out of two numbers. The number to the left of the decimal define the days since 01.01.1900. The number to the right of the decimal define the fraction of the day.
RoundOptional. Defines if value should be rounded. Default is true.

Return Value

Second evaluated from date value.

Example

FunctionResultComment
=SECOND(43238.5)0The given date value represents the 18th of May, 2018, 12:00
=SECOND(43930.999999, true)0Rounded to 0
=SECOND(43930.999999, false)59Same as before but prevent rounding