Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Time in Pivots.
I have a large DB, this is a small example,
Client Date Time 1 5/31/2010 9:32:43 AM 1 5/31/2010 9:34:21 AM 1 5/31/2010 10:51:39 AM 3 5/31/2010 11:10:13 PM 3 5/31/2010 03:13:10 PM 5 5/31/2010 05:42:01 PM 5 5/31/2010 06:45:43 PM 2 5/31/2010 06:47:11 PM 4 5/31/2010 08:50:31 PM I would like to create a pivot table that will count how many times each client placed an order between these time groups, 9:00 am - 4:00 pm 4:01 pm - 6:00 pm 6:01 pm - 11:59 pm Each entry is one order placed.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivots | Charts and Charting in Excel | |||
Pvtbl Grouping: Time Duration | Excel Discussion (Misc queries) | |||
several pivots | Excel Discussion (Misc queries) | |||
PivotTable grouping by Time Elapsed problem | Excel Discussion (Misc queries) | |||
Grouping a Set of Data By Time Interval | Excel Discussion (Misc queries) |