Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
Grouping Data in Excel | Excel Discussion (Misc queries) | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel |