VBA Minute function

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Minute Function Description

The VBA Minute function returns the number of minutes for the provided time value (date variable). Values range between 0 and 59.


The syntax for the Minute function in VBA is:

Minute( time )


The time (Date) value for which the minutes are to be returned. This can be a Date variable or string expressing date/time e.g. “20:10”.

Example Usage

The Minute function can be used in VBA code. Let’s look at some VBA Minute function examples:

Minute "20:10"
'Result: 10

Minute #8:20:00 PM#
'Result: 20

Dim d as Date
d = #9:02:00 PM#
Debug.Print Minute(d)
'Result: 2

Simply the best place to learn Excel VBA