Access: Minute Function

In Access, the Minute function returns an Integer specifying a whole number between 0 and 59, inclusive, representing the minute of the hour.

The syntax for the Minute function is:

Minute ( time )

The required time argument is any numeric or string expression, that can represent a time. If number is Null, this function returns a Null.


Minute (#4:37:12 PM#)       returns 37
Minute(#11:24:12 AM#)       returns 24

VBA Code

Dim MyMinute As Integer 
MyMinute = Minute(#3:45:12 AM#)

This example uses the Minute function to obtain the minute of the hour from a specified time. Now the MyMinutee variable would contain the value of 45.

SQL query

You can also use the Minute function in a query.

SELECT Minute(#10:37:12 PM#) AS Expr1 
FROM Orders


Leave a Reply

Your email address will not be published.