The SECOND function calculates the number of seconds from 0 to 59 from a time_code. The function can take as argument either a time code or text.
For example, the formula
SECOND("22:14:10")
returns 10, the number of seconds into the 14th minute of the 22nd hour.
SECOND(0.01)
returns 24, as a 100th of a day is 14 minutes and 24 seconds exactly.
See also: