Table of contents
Collapse the table of content
Expand the table of content

Minute Function

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Returns a Variant ( Integer ) specifying a whole number between 0 and 59, inclusive, representing the minute of the hour. SyntaxMinute(time) The required timeargument is anyVariant, numeric expression, string expression, or any combination, that can represent a time. If time containsNull, Null is returned.


This example uses the Minute function to obtain the minute of the hour from a specified time. In the development environment, the time literal is displayed in short time format using the locale settings of your code.

Dim MyTime, MyMinute
MyTime = #4:35:17 PM#    ' Assign a time.
MyMinute = Minute(MyTime)    ' MyMinute contains 35.

© 2018 Microsoft