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 |
Examples of use
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.
Notes
–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.