Funzione di Google Sheets

MINUTE

Returns the minute component of a time value as an integer ranging from 0 to 59.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

MINUTE(serial_number)

The MINUTE function extracts the minute from a given time value. The time is provided as a serial number or a text string that Excel recognizes as a valid time format.

Argomenti

serial_numberobbligatorioThe time that contains the minute you want to find.

Esempi

=MINUTE("10:30:45 AM")

Risultato: 30

Extracts the minute part from the specified time string.

Domande frequenti

What does the function return if the time is invalid?

The function will return a #VALUE! error if the input cannot be recognized as a valid time.

Funzioni correlate

HOUR SECOND TIME