Sort a column with complex keys
I have a spreadsheet with multiple columns that I need to sort, by writing a macro, based on 2 keys.
2) Date and Time(occupies one cell in the spreadsheet)
I have sorted based on name, but I am having difficulty sorting the date based on date and time, as Excel does not recognize the "date and time" column as pertaining to a particular format.
An example would be:
Date and Time of Events | Events
01-SEP-2007 01:46:15 AM | Event3
01-SEP-2007 12:46:08 PM | Event4
01-NOV-2006 12:19:10 PM | Event2
01-SEP-2007 01:46:18 PM | Event5
02-AUG-2004 03:46:01 PM | Event1
How do I get the data sorted chronologically?