MINUTE Function in Google Sheets

Extract the minute from a given time using the MINUTE function.

MINUTE Function

The MINUTE function in Google Sheets extracts the minute from a given time.

Syntax

MINUTE(time)
  • time: The time from which to extract the minute.

Examples

  1. Extract Minute from Time

Extract the minute from 13:45:30:

=MINUTE("13:45:30")
  1. Extract Minute from Current Time

Extract the minute from the current time:

=MINUTE(NOW())

Notes

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