The VBA MINUTE Function


The VBA Minute Function returns the minute component of a supplied time. The syntax of the function is:

Minute( time )

VBA Minute Function Example

A simple example of the VBA Minute function is shown below:

Const CurrTime = "17:56:33"
Dim MinNum As Integer

MinNum = Minute(CurrTime)

After running the above snippet of VBA code, the variable 'MinNum' holds the value 56, which is the minute component of the supplied time "17:56:33".