( by Tickclick )
I have a sheet which queries a column of dates as such: A1 = Date literal
query(data, "select * where C = date"""&text(A1, "yyyy-MM-dd)&""" ", 1)
how can I do the same thing with column B which has a time?
Have a look at the following screenshot of my Spreadsheet:
I have the following formula in Cell D1:=query(A:B, "select B where B >= timeofday '"&A1&"' label B 'Time' ", 0)
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.