The SECOND function returns the seconds of a time value, and can only be an integer from 0 to 59. The function will return an error when the second is greater than 59.
Formula:
= SECOND(serial_number)
Explanations:
Serial_number is required, the time value with the seconds you want to find.
Cautions:
Times can have different formats, such as
– A text string within quotation marks (e.g., "10:00 PM");
– A decimal number that represents the portion of the day value that is 24 hours (for example, 0.916666667, which represents 10:00 PM);
– A result of other formulas or functions (e.g., TIMEVALUE("10:00 PM")).
