I. Intro
You can use the MINUTE function to find the minute component of a specified time, with the result expressed as an integer.
II. About the function
- Formula: =MINUTE(time)
- Parameters:
- Time: The time that you want to find the minutes for.
- Example:
- In a cell, enter =MINUTE("23:59:00") or =MINUTE("23:59"). It will return a value of 59.
- Note:
- Use double quotation marks (") around the time in the formula.
- Set the cell format as either General or Number to ensure the correct results are displayed.
III. Steps
- Select a cell and click Formula in the toolbar, select All functions, and search for MINUTE. You can also directly enter =MINUTE in a cell.
- Enter the parameters (hours:minutes)
- Press Enter to display the result.
250px|700px|reset