Pivot Table - Volume by Day and Half Hour

[Excel Fox]

Wasn't sure what you were looking for exactly. Hope this is close.

[Ian Herndon]

That's just what I'm looking for! From that I could make a simple chart where the 30min intervals are on the x-axis and the count for each one is a point on the line. Then I'd have a separate line for each day of the week.

Since I'm so new to pivot tables I apologize if this is a basic question. So if I'm reading this correct, the pivot table is actually not reading the E column at all, but using the new time of day labels you made from column H which are then counted, is that right? If so, that seems like a pretty simple way to count the intervals. Great thinking. Trying to build off what you made I went and paste the rest of the data that wouldn't fit in my sample but I noticed the chart doesn't change so I suspect I have to expand the range somewhere. I noticed the formula for the H cells is =VLOOKUP(TIMEVALUE(E4&":00"),$Q$3:$R$50,2) where the only changing text in that is the E# field. Is it possible to drag that down so it duplicates to new rows of data I add for the rest of the days of the week? I tried but figure I might be doing something wrong since none of the numbers changed.

[Ian Herndon]

Actually I got it figured out! I made a second pivot table right below it and just kind of copied the placement of each of the field names into the various sections, row labels, values, etc. That is sooo much faster than what I was doing before it's crazy. Also, I noticed what was required to do that was pretty basic, yet really powerful at the same time. You've been a great help, ty so much sir!