G
GEM
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....
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....