SECOND function
SECOND returns the second for the given time value. The second is returned as an integer 0 - 59.
Syntax
SECOND(number)
number is a time value represented by a decimal for which the second is to be returned.
Example
=SECOND(NOW()) returns the current second.
=SECOND(C4)) returns 17 if the content of C4 is 17:20:17.
=SECOND(0.00019676)) returns 17 as the time value is the same as =SECOND(17/(24*60*60)) and corresponds to 12/30/1899 00:00:17.