Date
MINUTE
Definition
MINUTE returns the minute of a time, from 0 to 59.
Syntax
=MINUTE(serial_number)
Arguments
| Argument | Meaning |
|---|---|
serial_number |
A time, or the cell holding it. |
Worked example
A ferry log stores departure times. Times are in A2:A4.
| A: Depart |
|---|
| 14:45 |
| 7:10 |
| 23:05 |
Formula: =MINUTE(A2)
Result: 45. 14:45 has 45 in the minutes place. Filled down, the formula gives 45, 10, and 5.
Practice
Cell A2 holds 9:30. In B2, write a formula that returns the minute of that time.
- In B2, write a MINUTE formula for A2.
- B2 should show the minute of A2.
Step 1 of 2
Enter =MINUTE(A2) in B2.
A2 is 9:30, so the minute is 30.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses MINUTE.
B2 now shows 30.
Related functions
HOUR returns the other part of the same clock value. TIME builds that value from hour, minute, and second.
Common mistake
Using HOUR when you need minutes: HOUR(9:30) is 9, not 30.