How to Use Excel MINUTE Function?
Excel Minute Function is used to return minute as a numerical value (0-59) from given input time
TL;DR
The MINUTE function extracts the minute component and returns a numerical value from a given input time value (ranging from 0 to 59). It ignores the hour and second parts of the time. The syntax of the MINUTE function is =MINUTE(serial_number) and the serial_number is a valid Excel time or datetime. Find more Excel tutorials on our HomePage: Excel24x7.com
MINUTE Function: A Brief
The MINUTE function in Excel is used to extract the minute portion from a given input time value and returns the output as the numerical value (0-59).
Note: MINUTE function will return #VALUE! error, when there is an issue with your inputs or used invalid starting or ending dates. You can fix this by providing a proper time values without any hidden characters.
MINUTE Function: A Syntax
=MINUTE(time_value)- time_value: A valid Excel time or a cell containing a time value.
- The result will always be an integer between 0 and 59.
Basic Examples of using MINUTE Function:
The example below shows how to use the MINUTE function in Excel effectively for different situations.
| Formula Used | =MINUTE(B4) |
| S.no | Input Time | Result | Comments |
|---|---|---|---|
| 1 | 08:15:00 | 15 | Extracted 15 minutes from the time |
| 2 | 12:45:30 | 45 | Extracted 45 minutes from a full time value |
| 3 | 00:00:59 | 0 | Only seconds present, so minute is zero |
| 4 | 23:00:00 | 0 | Exact hour without any minutes |
| 5 | 14:29 | 29 | Recognized 29 minutes from a short time format |
| 6 | 09:00:00 | 0 | 0 minutes since it’s an exact hour |
Example Explanation:
The 1st one, This time has 15 minutes, so the MINUTE function returns 15. It completely ignores the hour and second values.
The 2nd one, The time includes 45 minutes and 30 seconds, but the function only extracts 45 minutes. It doesn’t round off based on seconds.
The 3rd one, Even though the time includes 59 seconds, there are 0 minutes, so MINUTE returns 0. It only looks at the MM part of the HH:MM:SS format.
The 4th one, This is an exact hour value with 00 minutes and 00 seconds, so the function returns 0.
The 5th one, The time is written in a short format (HH:MM), but Excel still detects and returns 29 minutes correctly. The function works with both short and full time formats.
The 6th one, This is a full hour without any minute or second part. As there are no minutes, MINUTE returns 0.
Using MINUTE Function with other Nested Functions:
| S.no | Scenario | Input | Formula Used | Output | Explanation |
|---|---|---|---|---|---|
| 1 | Check if task started late | 14:35:22 | =IF(MINUTE(C4)>30,”Late”,”On Time”) | Late | Checks if the minute part is greater than 30 and returns “Late” or “On Time”. |
| 2 | Add buffer time to extracted minute | 07:45:00 | =MINUTE(C5)+15 | 60 | Adds 15 minutes to the extracted 45 minutes. |
| 3 | Format minutes as text | 22:59:00 | =TEXT(MINUTE(C6),”00″) & ” minutes past the hour” | 59 minutes past the hour | Converts the minute into a string with leading zero. |
| 4 | Multiply minute by hourly rate unit | 09:20:00 | =MINUTE(C7)*2 | 40 | Multiplies extracted 20 minutes by 2. |
| 5 | Compare minute with reference value | 11:50:00 | =IF(MINUTE(C8)=45,”Matched”,”Different”) | Different | Compares minute (50) with 45 and returns result based on match. |
| 6 | Reconstruct time from hour & minute | 12:30:00 | =HOUR(C9)&”:”&MINUTE(C9) | 12:30 | Joins the hour and minute as a formatted string. |
| 7 | Get remainder of minute value | 18:10:00 | =MOD(MINUTE(C10),10) | 0 | Gets the remainder of 10 ÷ 10, useful for grouping or intervals. |
| 8 | Show minute difference from now | 06:45 | =ABS(MINUTE(NOW()) – MINUTE(C11)) | 6 | Displays the difference in minutes between current time and given time. |
Example Explanations:
First one: This formula checks if the minute value is greater than 30. If true, it returns “Late”. Otherwise, it shows “On Time”.
Second one: It takes the minute from a time and adds 15 minutes as a buffer. Useful for adding a grace period or delay in schedules.
Third one: Converts the minute into a two-digit text using the TEXT function and adds a label like “minutes past the hour”.
Fourth one: Multiplies the minute value by a fixed rate. This is helpful for calculating costs or units based on time.
Fifth one: Compares the extracted minute value to a set target (like 45). Returns “Matched” if they are equal, otherwise “Different”.
Sixth one: Combines the hour and minute from a time value using & to create a string such as “12:30”.
Seventh one: Uses the MOD function to find the remainder when minutes are divided by 10. Good for grouping into 10-minute blocks.
Eighth one: Subtracts the minute from a given time from the current time’s minute. Can return positive or negative values. Set the cell format to General to see the numeric result.
That’s it.
Feel free to comment us below, if you have any queries about the above topic and find more interesting excel tutorials on our homepage: Excel24x7.com.
References:
- Excel MINUTE function returns 0:00 by Stackoverflow, Retrieved on 17/04/2025: Link.
- Format cell as minutes for use in time calculation? by SuperUser, Retrieved on 17/04/2025: Link.
- How to extract minutes from a date time value in Excel | How To Use Minute Function In Excel by The Data Millennials, Retrieved on 17/04/2025: Link.
- How to use Minute function in Excel by Excel Tip, Retrieved on 17/04/2025: Link.
- How to use MINUTE function in Excel 2016 by Evergreen Tutorials, Retrieved on 17/04/2025: Link.
