Hi !
My spreadsheet looks a little like the following

a 2:10:43 4/10/15
a 2:15:34 4/10/15
a 2:45:23 4/10/15
a 4:45:34 5/10/15
a 6:40:15 6/10/15
a 3:09:56 7/10/15
a 1:23:22 8/10/15
a 2:45:06 8/10/15
a 2:20:54 8/10/15
a 4:10:31 8/10/15

So I need to treat every 'a' that has occurred in the period of an hour of the same day as one event. How do I filter my data to show this.

Thanks in advance !

Nitya