How to Use SECOND Function

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.


= SECOND(serial_number)


Serial_number is required, the time value with the seconds you want to find.


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")).

Leave a Reply