SECOND function

SECOND returns the second for the given time value. The second is returned as an integer 0 - 59.



number is a time value represented by a decimal for which the second is to be returned.


=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.