Returns the seconds of a time value as an integer from 0 to 59.
Söz dizimi
SECOND(serial_number)Bağımsız değişkenler
serial_numberzorunlu
The time that contains the second you want to find.
The SECOND function extracts the seconds component from a given time value. The result is an integer ranging from 0 for the beginning of a minute to 59 for the end of a minute.
=SECOND("12:30:45")→45Extracts the seconds from the provided time string.
Select a cell
Click on the cell where you want the result to appear.
Enter the formula
Type =SECOND( followed by the time reference and a closing parenthesis.
The function will return a #VALUE! error.