counting instances
I have 2 columns of times. Essentailly, the times are customer in and
customer out times. I want to show "how many customers are here at any given
hour?"
I have a graph with columns for each hour of the day. I want to populate
that graph. For example, if 4:30 pm falls between the 2 times, count one for
the "4-5pm" column on the graph.
Any ideas? I have about 8,000 lines of data. THANK YOU!
|