I am not sure what to use here. what I am trying to do is sort by Day and hour and name. The minutes arent needed, and what is hanging me up. The number of rows in the column can vary.as can the names like Frank and Bill. For instance, I would like to see how many Frank did in the hour of 14:00 (2pm-2:59) and do that for every hour of the day and get a total for that name, for every hour of each date. I hope I am making sense, and any help would really be appreciated!
Frank 12/30/2004 2:58
Frank 1/1/2005 22:52
Frank 1/2/2005 11:33
Bill 1/2/2005 22:46
Frank 1/3/2005 13:30
Frank 1/3/2005 14:21
Frank 1/3/2005 14:59
Bill 1/3/2005 16:40
Frank 1/3/2005 22:02
Frank 1/4/2005 11:48
Frank 1/5/2005 10:37
Bill 1/5/2005 13:58
Frank 12/30/2004 2:58
Frank 1/1/2005 22:52
Frank 1/2/2005 11:33
Bill 1/2/2005 22:46
Frank 1/3/2005 13:30
Frank 1/3/2005 14:21
Frank 1/3/2005 14:59
Bill 1/3/2005 16:40
Frank 1/3/2005 22:02
Frank 1/4/2005 11:48
Frank 1/5/2005 10:37
Bill 1/5/2005 13:58