MINUTE

The MINUTE function returns minutes from 0 to 59 of the specified time.

This function can be useful when you need to work with time-based data and analyze it by the minute.

Syntax

MINUTE(time)

Argument	Description	Permitted values
time	The value of the time from which the number of minutes is retrieved	Reference to a cell containing a date, a function that returns a date value, a row containing a date or time in a valid format

Retrieving minutes from time

If you have the time in cell A1, for example, 12:45, you can get the minutes as follows:

=MINUTE(A1)

Result: 45.

Working with time values

You can also specify the time directly in the formula:

=MINUTE("14:30")

Result: 30.

Retrieving minutes from the current time

If you want to obtain the current time in minutes, you can use:

=MINUTE(NOW())

This formula will return the number of minutes from the current time.

Make sure that the time value has the correct format, otherwise the function will return an error.
The MINUTE function will return a value between 0 and 59.
Objects of the “Date” type without an explicit time specification will contain a zero time value.