How to create a combo box of time with increment of certain interval?

[latex88]

How do I create a combo box listing all the time available between now and end at certain time of today with increment of certain interval? Example below.

I started to load a table worth of time in the range of 6:00am to 11:00pm and created a query with criteria of > now (). It resulted nothing. I guess the list of time should include actual dates? If so, then it wouldn't be so dynamic in the future.

1:55pm
2:00pm
2:05pm
.
.
.
.
11:00pm

 

[pbaldy]

Now() includes the date. Try

> TimeValue(Now())

 

[latex88]

That works great. Thanks.

 

[pbaldy]

Happy to help.