The SECOND function returns the seconds for a given date/time value or time string.
SECOND(time)
time: A date/time value or time string.
Example
=SECOND(“4/6/88 11:59:22pm”) returns 22.
