Hello. I work for a call center, and have been asked to collate some data. I'm hoping I can get Excel to do one of the tedious tasks for me.
I've got a spreadsheet where calls are listed and the times they came in. What I'm looking to do is find out how many calls came in during each half hour increment.
So column "A" shows the times the calls came in. I picture column "B" having a list of half hour increments (10:30-11:00, 11:00-11:30, 11:30-12:00, etc) then column "C" showing the number of calls in column "A" that fit within each increment of column "B".
Any tips on how I might pull this off? Thanks alot!
I've got a spreadsheet where calls are listed and the times they came in. What I'm looking to do is find out how many calls came in during each half hour increment.
So column "A" shows the times the calls came in. I picture column "B" having a list of half hour increments (10:30-11:00, 11:00-11:30, 11:30-12:00, etc) then column "C" showing the number of calls in column "A" that fit within each increment of column "B".
Any tips on how I might pull this off? Thanks alot!