Given the following list of dates:
7/24/2005 12:15
7/21/2005 13:36
7/27/2005 15:03
7/14/2005 15:07
7/15/2005 16:26
7/8/2005 11:55
in custom format: m/d/yyyy h:mm
I need to be able say there were [the max # of logins in an hour on a single Sunday (as opposed to all Sundays)] happened on [Date] [Hour].
I need to be able to make that statement for each day of the week. Actual list contains 5100 entries, each entry is a login time.
In words, I need to be able say on this date, there were 55 logins in the 13:00 hour, and that was the most people logged into a server in an hour on a Sunday in the entire month.
Thank you so much for your help.
Bookmarks