Table of Contents
This guide explains how to use MINUTE Function in Excel, including its syntax, required arguments, practical examples, and common errors.
Description: The function returns the minute value of a time value. Minutes are returned as integers between 1 and 59.
Syntax : MINUTE (serial_number) .
Inside:
serial_number is the time value that wants to separate the minute value.
For example: Separate the minute value in the following time value:
In the cell to calculate enter the formula: = MINUTE (C7) .
Press Enter -> minute values are separated in time value:
Similarly copying the formula for the remaining cells results:
In case you enter the wrong value of minutes, it exceeds 59 function returns #VALUE!
Above is the usage and some special cases when using the Minute function.
Good luck!
FAQ
What does the MINUTE function do in Excel?
The MINUTE function performs the calculation described in this guide. Use the correct arguments and compatible data types for reliable results.
How do I enter the MINUTE function correctly?
Start with an equals sign, enter MINUTE, add the required arguments inside parentheses, and confirm that cell references and separators are correct.
Why does the MINUTE function return an error?
Common causes include missing arguments, invalid data types, incorrect cell references, unsupported values, or regional separator settings.
Related Articles
How to Use the HOUR Function in Excel2 minutes read
How to Use the MONTH Function in Excel2 minutes read
How to Use the DATEVALUE Function in Excel3 minutes read
How to Use the MONTH Function in Excel2 minutes read
How to Use the DATEVALUE Function in Excel3 minutes read
The VALUE Function Converts a Numeric String to a Number3 minutes read
Reader Comments 0
Sign in with email or Google to join the discussion.