MS Excel: Minute Function

In Excel, the Minute function returns the minute of a time value (from 0 to 59).

The syntax for the Minute function is:

Minute( serial_number )

serial_number is the time value to extract the minute from. It may be expressed as a string value, a decimal number, or the result of a formula.

Applies To:

For example:

Let's take a look at an example:

Based on the spreadsheet above, the function would return the following values:

=Minute(A1) would return 14

=Minute(A2) would return 12

=Minute("4:00:00 AM") would return 0

=Minute("4:30:00 AM") would return 30

VBA Code

The Minute function can be used in VBA code. For example:

Dim LMinute As Integer

LMinute = Minute("10:13:58 AM")

In this example, the variable called LMinute would now contain the value of 13.