MINUTE function
Quick answer
MINUTE returns the minutes part of a time as a number from 0 to 59, so 1:45 PM gives 45.
- Syntax
=MINUTE(serial_number)- Most common use
=MINUTE(A2)returns 45 (1:45 PM gives 45)
Use it with HOUR to split timestamps into parts, round times to the quarter hour, or check how many minutes past the hour something happened. It ignores the date part of a date and time.
- Available in
- Every current version
- Category
- Date functions
- Returns
- A whole number from 0 to 59.
- Google Sheets
- Works the same in Google Sheets.
Syntax
=MINUTE(serial_number)
| Argument | Required? | What it is |
|---|---|---|
serial_number | Required | A time, a date and time, or time text. |
Examples
Each result below is calculated from the sample sheet by our formula engine, the same one that grades the practice.
| Cell | Formula | Result | What it shows |
|---|---|---|---|
| B2 | =MINUTE(A2) | 45 | 1:45 PM gives 45 |
| B3 | =MINUTE(A3) | 30 | 7:30 AM gives 30 |
| B4 | =HOUR(A2)*60+MINUTE(A2) | 825 | Minutes since midnight: 825 |
Try it live
This is the sample sheet. Change any number or text, or edit a formula, and the results update.
Show the sample data as a table
| Timestamp | Result |
| 1/5/2026 13:45:00 | 45 |
| 7:30 AM | 30 |
| 6:05 PM | 825 |
Practice MINUTE
Graded instantly, then re-checked on changed data.
Minutes past the hour
In
B2, return how many minutes past the hour each call started, from the times in A2. Fill down to B7.Common mistakes
| What you see | Why, and how to fix it |
|---|---|
| #VALUE! | The cell holds text that isn't a time. |
| The minutes of a duration over an hour | MINUTE only returns 0–59. For total minutes in a duration, use =A2*1440. |
Tips
- =A2*1440 turns a duration into total minutes, which MINUTE can't do.
Questions
How do I get the minutes from a time in Excel?
=MINUTE(A2) returns the minutes part, 0–59.
How do I convert a time to total minutes?
Multiply by 1440, the minutes in a day: =A2*1440.
Updated Checked by running: every formula on this page was run by our formula engine on .