Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Ranges
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If and Date Ranges | Excel Worksheet Functions | |||
Using IF and date ranges | Excel Worksheet Functions | |||
date ranges | Excel Worksheet Functions | |||
Date ranges | Excel Worksheet Functions | |||
compare date to various date ranges and sum value | Excel Worksheet Functions |