Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting Dates in Days of the Week
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] 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. Thank you so much for your help. -- Eagle784 ------------------------------------------------------------------------ Eagle784's Profile: http://www.excelforum.com/member.php...o&userid=24261 View this thread: http://www.excelforum.com/showthread...hreadid=396973 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user defined function | Excel Worksheet Functions | |||
Brainteaser about Days Between Dates | Excel Discussion (Misc queries) | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
how do I calculate the days between dates? | Excel Discussion (Misc queries) | |||
Subracting Dates to come up with the # of days between them | Excel Worksheet Functions |