Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

SECOND

Returns the second for the given time value. The second is given as an integer in the range 0 to 59.

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)

Syntax

SECOND(Number)

Number, as a time value, is a decimal, for which the second is to be returned.

Example

=SECOND(NOW()) returns the current second

=SECOND(C4) returns 17 if contents of C4 = 12:20:17.