Grouping Data
 

I have the following data:

Code:
--------------------
22/03/2006 0:10
22/03/2006 3:22
22/03/2006 8:59
22/03/2006 11:12
22/03/2006 13:31
22/03/2006 13:56
22/03/2006 14:16
22/03/2006 14:22
22/03/2006 15:38
22/03/2006 15:40
22/03/2006 16:07
22/03/2006 16:58
22/03/2006 17:36

--------------------


I would like to know if it is possible to produce a report so that I
can see something lik ethe following:

22/03/2006 16:00 10
22/03/2006 17:00 5
-------------------------------
Column 1: Date
Column 2: Time
Column 3: Number of Entries within the last hour


--
ForgetMeNot
------------------------------------------------------------------------
ForgetMeNot's Profile: http://www.excelforum.com/member.php...o&userid=28583
View this thread: http://www.excelforum.com/showthread...hreadid=525590

Grouping Data
 

You could make an extra column which converts 16:05, 16:37 etc etc into
16,
then do a straight forward pivot table.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=525590