The Excel MINUTE Function

Home » Excel-Built-In-Functions » Excel-Date-And-Time-Functions » Excel-Minute-Function Search this site: Custom Search

Related Functions:  HOUR Function SECOND Function TIME Function

Basic Description

The Excel Minute function returns an integer representing the minutes component of a supplied Excel time.

The syntax of the Datevalue function is :

where the serial_number argument is the time from which you want to extract the minutes component. This can be supplied to the function either directly (as a text representation of a time or as a decimal value), as a reference to a cell containing a time, or as a time value returned from another function or formula.

Note that, if the serial_number argument is a date and time, the date part of the argument is ignored by the Minute function.

Minute Function Examples

The following spreadsheet shows the Excel Minute function applied to several different times. The spreadsheet on the left shows the format of the functions and the spreadsheet on the right shows the results.

Formulas:

Results:

Further information and examples of the Excel Minute function can be found on the Microsoft Office website.

Minute Function Error

If you get an error from the Excel Minute Function, this is likely to be the #VALUE! error :