Detailed method of using SECOND function in Excel table

Please see the following function usage demonstration.

Call the SECOND function, that is, enter [=SECOND] in the specified cell. Excel will automatically prompt the function of the function during the input process.

Set the time value to be extracted in seconds.

Click Enter to view the operation results; the value range is an integer between 0-59.

Extension example one:

If the parameter does not have seconds, 0 will be returned.

Extended example two:

The time value is in date format but expressed in Chinese characters, and the seconds can still be extracted.

Extended example three:

You need to pay attention during use. Because of the format problem, the time value may contain seconds and is not displayed, but use the function After calculation, the correct number of seconds is still returned. Please note!

Note:

If the parameter does not have seconds, 0 will be returned.

The value range of the function result is a positive integer between 0 and 59.

The above is the detailed content of Detailed method of using SECOND function in Excel table. For more information, please follow other related articles on the PHP Chinese website!