SECOND Function in Google Sheets

Extract the second from a given time using the SECOND function.

SECOND Function

The SECOND function in Google Sheets extracts the second from a given time.

Syntax

SECOND(time)
  • time: The time from which to extract the second.

Examples

  1. Extract Second from Time

Extract the second from 13:45:30:

=SECOND("13:45:30")
  1. Extract Second from Current Time

Extract the second from the current time:

=SECOND(NOW())

Notes

  • Returns an integer between 0 and 59.
  • Supports different time formats, including date-time combinations.
  • HOUR: Extracts the hour from a time.
  • MINUTE: Extracts the minute from a time.