Pivot Table - Volume by Day and Half Hour *unanswered for years*

Hi there! I've asked this similar question different ways through different forums for years now and most often don't even see a reply. Hope someone here can help!

Quick summary, I am trying to quantify the amount of volume for each day of the week broken down by half hour.

I have a long list of data which is broken down by hh:mm with a field to the right indicating which day of the week its from. I'm pretty unfamiliar with pivot tables though. How can I take data similar to below and chart out volume on particular days by half hour? 00:00-00:30 would be midnight to 12:30a.

Time of Day Day of Week
00:00 Monday
00:02 Monday
00:02 Monday
00:03 Monday
00:03 Monday
00:03 Monday
00:00 Tuesday
00:01 Tuesday
00:01 Tuesday
00:02 Tuesday
00:04 Tuesday
00:04 Tuesday
00:05 Tuesday


Thanks for any ideas you can suggest!

Checking now, thx!

yup that's exactly what I'm looking to do! I pasted more data into that sample file you attached but I see the pivot chart actually doesn't change even if I delete all the data from columns A & B. Is that possible with pivot tables where an existing working one based off of a small data set can be simply added onto?