Hi Biff,
I've been trying to figure out solving my problem particularly in this topic but unsuccessful. Could you or anyone who is reading this message help me? I'm working on a report/analysis that displays many crucial data. Out of these data, I'll narrow down to the important part that is (i) Name column, (ii) Date column and (iii) Time stamp (refer to attachment). My records are formatted according to the attached sample file. I'm trying to analyse these data to identify count of instances for each individual, hourly e.g.
(i) 9:00 a.m. to 9:59 a.m. represented by 9AM-10AM
(ii) 10:00 a.m. to 10:59 a.m. represented by 10AM-11AM
(iii) 11:00 a.m. to 11:59 a.m. represented by 11AM-12PM

I've tried using COUNTIFS formula but the results keep displaying "-" symbol. Please help. Thanks.

Regards,
B30K