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 Reference – Date Time functions

VBA Minute Syntax

The syntax for the Minute function in VBA is:

1
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:

1
2
3
4
5
6
7
8
9
10
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