I am trying to calculate number of customers who arrive every hour in a
day for theentire year.

suppose: the computer records the name and info of a person arrived and
stores the time he/she arrived like:

10:27 xyz
10:29 abc
10:45 123

so I want to calculate the total arrivals in an hour from 10:00-10:59
and I want to that for the entire 24 hour period and then for the
entire month for each hour,

Please let me know how could i do it in a faster way using exfel.

Thanks,
RP!