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.
Reply With Quote
Bookmarks