Extracted Data
1. Overview
Syntax | SECOND(Serial_number,Format) | Returns the second of a specified time. The second is an integer ranging from 0 to 59. |
Parameter 1 | Serial_number | Represents the time with the second to be returned. |
Parameter 2 | Format | For example, HH:mm:ss |
2. Notes
The function allows the parameter to be empty. That is to say, the function can be SECOND(). When the parameter is empty, the function returns the second corresponding to the current system server time.
The second parameter can be the default value.
3. Example
Formula | Result | Note |
SECOND() | 25 | The corresponding system server time is 2010-01-01 15:36:25. |
SECOND("15:36:25") | 25 | |
SECOND("15:36:25","HH:mm:ss") | 25 |
Real-Time Data
1. Overview
Syntax | SECOND(Serial_number) | Returns the second of a specified time. The second is an integer ranging from 0 to 59. |
Parameter | Serial_number | Represents the time with the second to be returned. |
2. Notes
The function allows the parameter to be empty. That is to say, the function can be SECOND(). When the parameter is empty, the function returns the second corresponding to the current system server time.
The parameter can be of the date or text type by default.
3. Example
Formula | Result | Note |
SECOND() | 25 | The corresponding system server time is 2010-01-01 15:36:25. |
SECOND("15:36:25") | 25 |
