Home » Excel-Built-In-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 format of the function is:

where the time argument can be supplied as a time value or a reference to a cell containing a time.

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

Examples

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

The MINUTE Function In VBA

The MINUTE function is also a built-in function in VBA (used for writing Excel Macros).

Within VBA, the function takes exactly the same format as when used in an Excel spreadsheet:

For example:

Const CurrTime = "17:56:33" Dim MinNum As Integer MinNum = Minute(CurrTime)

After running the above snippet of VBA code, the variable 'MinNum' holds the value 56, which is the minute component of the time "17:56:33".