How to use Minute function in VBA?

In VBA (Visual Basic for Applications), the Minute function is used to retrieve the minute portion from a given time. The time can be specified as a serial date-time code, or it can be passed directly as a string that represents time or a date-time value. The Minute function returns an integer value between 0 and 59. Here’s a basic example of how to use the Minute function:

Sub ExampleMinute()
    Dim currentTime As Date
    Dim minutes As Integer
    
    ' Set the current time
    currentTime = Now
    
    ' Retrieve the minute portion of the current time
    minutes = Minute(currentTime)
    
    ' Display the minutes in a message box
    MsgBox "The current minute is: " & minutes
End Sub
In this code, we’re using the Now function to get the current date and time, and then we use the Minute function to extract the minutes from the current time. Finally, we display this value in a message box. If you want to get the minutes from a specific time, not the current time, you could do this:

Sub GetMinutesFromSpecificTime()
    Dim specificTime As Date
    Dim minutes As Integer
    
    ' Specify a time
    specificTime = #1:30:45 PM#
    
    ' Retrieve the minute portion of the specified time
    minutes = Minute(specificTime)
    
    ' Display the minutes in a message box
    MsgBox "The minute is: " & minutes
End Sub
In this example, we’re using a specific hard-coded time within ## delimiters to denote a date/time literal in VBA. The Minute function then retrieves the minute part of that specific time. Keep in mind that Minute only returns the minute component of the time, if you need the hour or second, you would use the Hour or Second function respectively.

Unlock Your Potential

Excel

Basic - Advanced

Access

Access Basic - Advanced

Power BI

Power BI Basic - Advanced

Help us grow the project

Leave a Reply

Your email address will not be published. Required fields are marked *