The VBA MINUTE Function

Home » Excel-VBA-Tutorial » VBA-Operators-And-Functions » VBA-Minute-Function

Search this site:

Custom Search

Related Function:

VBA SECOND function

Description

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

Minute( time )

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".

Disclaimer