I have a spreadsheet with a times in a column in the "hh:mm" format.
I want to find the 21:45 time period in vba and insert it into a function as a variable.

So far I have
Dim NYClose As Date (is that correct to Dim a time as Date?)
NYClose= "21:45"

Am I going about this correctly?
What do I need to do to the "21:45" to make the NYClose variable the "21:45" time period I am looking for?

Thank you