How to use the MINUTE function
Article updated on April 19, 2018
Returns a whole number representing the minute based on an Excel time value. The returned number is ranging from 0 to 59.
Formula in cell C3:
=MINUTE(B3)
Excel Function Syntax
MINUTE(serial_number)
Arguments
| serial_number | Required. An Excel time value that you want to extract the minute from. |
Comments
Excel time (serial_number) is actually a number ranging between 0 and 1 in Excel and then formatted as time.
Example, 12:00 PM is represented as 0.5 because it is half of a day, you can verify this by typing 12:00 PM in a cell and then change the cell formatting to general.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas.
Click on headers to sort table.
Article with the 'MINUTE' Function
The following article has a formula that contains the MINUTE function.
Column C contains both date and time, to calculate the average of only time we need to extract the hours, minutes […]
Functions in 'Date and Time'
The MINUTE function function is one of many functions in the 'Date and Time' category.
The DATE function returns a number that acts as a date in the Excel environment. The image above shows you […]
The DATEDIF function returns the number of days, months, or years between two dates. The DATEDIF function exists in order to […]
The DATEVALUE function returns an Excel date value (serial number) based on a date stored as text. Excel Function Syntax […]
The DAY function extracts the day as a number from an Excel date. Formula in cell C3: =DAY(B3) Excel Function […]
The DATE function calculates the number of days between two dates. Formula in cell D3: =DAYS(B3,C3) Excel Function Syntax DAYS(end_date, […]
The EDATE function returns a date determined by a start date and a number representing how many months. Use EDATE […]
The EOMONTH function returns an Excel date for the last day of a given month using a number and a start […]
Returns an integer representing the hour of an Excel time value. The returning number is ranging from 0 (12:00 A.M.) […]
Returns a whole number representing the minute based on an Excel time value. The returned number is ranging from 0 […]
Extracts the month as a number from an Excel date. Formula in cell C3: =MONTH(B3) Excel Function Syntax MONTH(serial_number) Arguments […]
The NETWORKDAYS function returns the number of working days between two dates, excluding weekends. It also allows you to ignore […]
The NOW function returns the current date and time. Formula in cell B3: =NOW() Excel Function Syntax NOW() Arguments The […]
Returns an integer representing the second based on an Excel time value. The returning number is ranging from 0 to […]
The TIME function returns a decimal value between 0 (zero) representing 12:00:00 AM and 0.99988426 representing 11:59:59 P.M. Formula in cell […]
The TIMEVALUE function returns a decimal number based on a text string. Excel uses decimal numbers between 0 and 0.99988426 […]
The TODAY function returns the Excel date (serial number) of the current date. Warning! This function is volatile meaning it […]
Converts a date to a weekday number from 1 to 7. Formula in cell D3: =WEEKDAY(B3) Excel Function Syntax WEEKDAY(serial_number,[return_type]) […]
The YEAR function converts a date to a number representing the year in the date. The number is between 1900 […]
