Returns the second corresponding to serial_number. The second is given as an integer in the range 0 (zero) to 59. Use SECOND to get the time in seconds indicated by a serial number.
Syntax
SECOND(serial_number)
Serial_number is the date-time code used by Microsoft Excel for date and time calculations. You can give serial_number as text, such as "16:48:23" or "4:48:47 PM", instead of as a number. The text is automatically converted to a serial number. For more information about serial_number, see NOW.
Remarks
Microsoft Excel for Windows and Microsoft Excel for the Macintosh use different date systems as their default. For more information, see NOW.
Examples
SECOND("4:48:18 PM")
equals 18
SECOND(0.01)
equals 24
SECOND(4.02)
equals 48