MINUTE Function
Returns the minutes from a time.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A number from 0 to 59
Overview
MINUTE returns the minute part of a time, from 0 to 59.
Pair it with HOUR to break a time or a duration into parts.
Syntax
=MINUTE(serial_number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| serial_number | Yes | A time, a date with a time, or time text. |
Examples
Example 1 — Minutes past the hour
Pull the minutes out of each time.
B2fx=MINUTE(A2)
| A | B | |
|---|---|---|
| 1 | Time | Minute |
| 2 | 9:30 AM | 30 |
| 3 | 6:45 PM | 45 |
| 4 | 12:05 AM | 5 |
=MINUTE(A2) Explain
Example 2 — Meeting length in minutes
Turn the gap between two times into whole minutes.
C2fx=HOUR(B2-A2)*60+MINUTE(B2-A2)
| A | B | C | |
|---|---|---|---|
| 1 | Start | End | Minutes |
| 2 | 9:15 AM | 11:50 AM | 155 |
=HOUR(B2-A2)*60+MINUTE(B2-A2) Explain
=ROUND((B2-A2)*1440, 0) gives the same answer — there are 1,440 minutes in a day.
Common mistakes
- MINUTE of a duration over an hour. MINUTE only returns the leftover minutes (2:35 gives 35). Multiply by 1440 for total minutes.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.