Date Ranges

[Liz J]

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!

 

[Herbert Seidenberg]

Excel 2007
PivotTable, Group by day, hour
http://www.mediafire.com/file/jlmoqnutn5t/01_15_09.xlsx

 

[Ron Rosenfeld]

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!

Set up your pivot table with the Date/Time as Row Labels, and the Transactions
in the Values (or Data) area (using the SUM function).

Then Group your Row Labels by Hours, or, if you also want to split up the days,
by Hours and Days.
--ron