VBA Minute

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.

VBA Minute Syntax

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