VBA Functions: Hour, Minute, and Second

The VBA functions Hour, Minute, and Second return an integer corresponding to the hour, minute, or second of the specified date or time.

Usage:

Hour(date_time)

Minute(date_time)

Second(date_time)

Example of Usage

Using the Hour, Minute, and Second functions to retrieve corresponding information from a time:

Sub example()

    myTime = #6:36:45 PM#

    MsgBox Hour(myTime) 'Returns: 18
    MsgBox Minute(myTime) 'Returns: 36
    MsgBox Second(myTime) 'Returns: 45

End Sub

Or based on a date and time (for the same result):

Sub example()

    myDateTime = #10/31/2024 6:36:45 PM#

    MsgBox Hour(myDateTime) 'Returns: 18
    MsgBox Minute(myDateTime) 'Returns: 36
    MsgBox Second(myDateTime) 'Returns: 45

End Sub

These functions also accept date and time strings:

Sub example()

    myDateTime = "10/31/2024 18:36:45"

    MsgBox Hour(myDateTime) 'Returns: 18
    MsgBox Minute(myDateTime) 'Returns: 36
    MsgBox Second(myDateTime) 'Returns: 45

End Sub