View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AndrewC AndrewC is offline
external usenet poster
 
Posts: 11
Default 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!