Second of minute from Duration

Returns the number of seconds explicitly specified if identifiable, or 0 if a second is not found.

Sample usage

SECOND("007:14:21") returns 21

SECOND(TIMENOW() - "00:00:00") returns seconds since the top of the minute; the current second of the minute. See also: TIMENOW()

Seconds in Duration

SECOND() merely extracts the seconds component from a Duration value; it does not compute the number of seconds the Duration value represents in total. To compute the total seconds comprising a Duration value, use TOTALSECONDS().

Common problems

SECOND(NOW()) (or any DateTime or Time value in place of NOW()) causes Expression Assistant to complain, Parameter 1 of function SECOND is of the wrong type. The argument must be a Duration value, not a DateTime or Time value. To fix, convert a DateTime value to a Time value with TIME(), then subtract a zero time to convert a Time value to a Duration value: SECOND(TIME(NOW()) - "00:00:00"). See also: NOW(), TIME()



  • duration - A Duration value.


SECOND(...) is equivalent to (NUMBER(INDEX(SPLIT(TEXT(...), ":"), 3)) + 0) when ... is a Time value. See also: INDEX(), NUMBER(), SPLIT(), TEXT()

See also

Date and time expressions



Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Clear search
Close search
Google apps
Main menu