I am looking at time versus transaction amount data to create a pivot table.
In column D of my spreadsheet, I am looking at date and hour (ex: 1/15/2009
13:17). Column E shows the number of transactions made at the point of time
indicate in column D. I'm interested to see the total of transactions made in
hour increments. So, my end goal is to find how many total transactions from
9:00-10:00, 10:01-11:00, 12:00-13:00, and so on. Since column D has such
specific data, how to do I manipulate the data such that I can achieve my
goal?

Thanks for any and all of the help you can provide!