In this Article
This tutorial demonstrates how to use the Excel MINUTE Function in Excel to get the minute of time.
MINUTE Function Overview
The MINUTE Function Returns the minute as a number (0-59).
To use the MINUTE Excel Worksheet Function, Select cell and Type:
(Notice how the formula input appear)
MINUTE Function syntax and Inputs:
1 |
=MINUTE(serial_number) |
serial_number – The time, represented as a fraction of the day or entered as time surrounded by quotations (“s”). Example: You can not enter 8:00:00 pm directly into the cell. Instead you would need to use the corresponding fraction of the day: .3333 or the time surrounded by quorations: “8:00:00 pm”. Alternatively, you can reference a cell with the time entered. Excel automatically converts times stored in cells into a fractional number (unless the time is stored as text).
Minute Examples
The MINUTE Function returns the minute number of a time:
1 |
=MINUTE(B4) |
MINUTE and TIME Functions
Using the TIME and MINUTE Functions you can create a new time with the minute number from the original time:
1 |
=TIME(10,MINUTE(B4),20) |
MINUTE in Google Sheets
The MINUTE Function works exactly the same in Google Sheets as in Excel:
MINUTE Examples in VBA
You can also use the MINUTE function in VBA. Type:
application.worksheetfunction.minute(serial_number)
For the function arguments (serial_number, etc.), you can either enter them directly into the function, or define variables to use instead.
Return to the List of all Functions in Excel