Looking to get the count of rows that fall within a certain hour of the day.
I can perform
IF statements against the times, but not
So far I have tried:
And even tried hard coding the times in, e.g.:
Also not really sure if/why
TIMEVALUE is needed, since it seems I am working with actual datetime cells... however it seemed to help on the
Here is my sample spreadsheet showing data: https://docs.google.com/spreadsheets/d/1gEmuc00W1sY_TClx1uR9lqYRRtsHzzWyQvO8o3G8epE/edit#gid=255648219