VBA Minute function

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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.

Syntax

The syntax for the Minute function in VBA is:

Minute( time )

Parameters

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