Date Ranges
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! |
Date Ranges
|
Date Ranges
On Thu, 15 Jan 2009 13:34:03 -0800, Liz J
wrote: 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 |
All times are GMT +1. The time now is 08:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com