Thanks for for the welcome and the reply.

The chart you built isn't exactly what i needed. Since there are more than 1 of each job code present throughout the day. The average should be higher than one.

I think I will have to use a COUNTIF function to get my avgerages per half hour. I was hoping to be able to do this in a pivot chart.