I have a excel sheet of jobs that we get daily. What is included in that data are the times these jobs hit our system.

I wanted to know if there is a easier formula or a VBA code that will allow me to see how many jobs are presented with in a certain time period. In this case it is in a 24 hour period in 15min increments on a daily basis. So this would mean I would 96 lines of criteria to evaluate.

Now, with that being said this is how I attempted to solve the problem. The formula I was using is this:

IF(AND(cell>criteria<cell<criteria,"A",""))

IF(AND(cell>criteria<cell<criteria,"B",""))

and so on...............

Then do a =COUNTIF(range:range,"A","") and the bottom

as you can see this can get bit hairy. Their would be too many formulas to drag.

Is there an easier way? Please help!!!

Thanks

Gmatriix