I have code that combines the text of two text boxes. It is a date and time combination. For example

dateplus = cdate(startdate.text & " " & stopdate.text, "mmddyyhhnn")

now I want to break this back down to just the time to compare to another time. I need to use the time the dateplus value has accumulated and not the original time.

In other words I need to break down and get just the time out of the date plus value in order to set a condition of it is is greater than cdate("9:59pm")

Suggestions?