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). MINUTE minute 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. Note: #VALUE! error MINUTE Function: A Syntax =MINUTE(time_value) =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. time_value: A valid Excel time or a cell containing a time value. time_value The result will always be an integer between 0 and 59. 0 59 Basic Examples of using MINUTE Function: The example below shows how to use the MINUTE function in Excel effectively for different situations. MINUTE Formula Used =MINUTE(B4) Formula Used =MINUTE(B4) Formula Used =MINUTE(B4) Formula Used Formula Used Formula Used =MINUTE(B4) =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 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 S.no Input Time Result Comments S.no S.no Input Time Input Time Result Result Comments Comments 1 08:15:00 15 Extracted 15 minutes from the time 1 1 08:15:00 08:15:00 15 15 Extracted 15 minutes from the time Extracted 15 minutes from the time 2 12:45:30 45 Extracted 45 minutes from a full time value 2 2 12:45:30 12:45:30 45 45 Extracted 45 minutes from a full time value Extracted 45 minutes from a full time value 3 00:00:59 0 Only seconds present, so minute is zero 3 3 00:00:59 00:00:59 0 0 Only seconds present, so minute is zero Only seconds present, so minute is zero 4 23:00:00 0 Exact hour without any minutes 4 4 23:00:00 23:00:00 0 0 Exact hour without any minutes Exact hour without any minutes 5 14:29 29 Recognized 29 minutes from a short time format 5 5 14:29 14:29 29 29 Recognized 29 minutes from a short time format Recognized 29 minutes from a short time format 6 09:00:00 0 0 minutes since it’s an exact hour 6 6 09:00:00 09:00:00 0 0 0 minutes since it’s an exact hour 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. 15 minutes MINUTE 15 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. 45 minutes and 30 seconds 45 minutes 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. 59 seconds 0 minutes MINUTE 0 MM HH:MM:SS The 4th one, This is an exact hour value with 00 minutes and 00 seconds, so the function returns 0. 00 minutes and 00 seconds 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. short format (HH:MM) 29 minutes The 6th one, This is a full hour without any minute or second part. As there are no minutes, MINUTE returns 0. MINUTE 0 Using MINUTE Function with other Nested Functions: 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”. First one 30 “Late” “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. Second one minute 15 minutes Third one: Converts the minute into a two-digit text using the TEXT function and adds a label like “minutes past the hour”. Third one minute two-digit TEXT “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. Fourth one rate Fifth one: Compares the extracted minute value to a set target (like 45). Returns “Matched” if they are equal, otherwise “Different”. Fifth one target “Matched” “Different” Sixth one: Combines the hour and minute from a time value using & to create a string such as “12:30”. Sixth one hour and minute & “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. Seventh one MOD remainder 10 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. Eighth one minute positive or negative General That’s it. This tutorial is first published on How to Use Excel MINUTE Function? How to Use Excel MINUTE Function?
