Try reformatting it to be just the time, first. Right click, and select "Format cells" and it'll tell you you have a custom format that includes date and hours and minutes. Select a format that "hh:mm"
Try sorting on that. It may or may not work- Depends if it still uses the data you have formatted out of view. Probably won't work, but worth a try as a easy way to do it.
If that doesn't work, you need to parse the data field.
Select "Data" then "Text to columns"
Select "Delimited" and then check the box for "space"
Interestingly, the data field in my version of excel, 2003, acts like 12-hour time, even though its displayed as a 24-hour clock. So doing the above parses off a "PM" and turns the remaining time field into an "AM" Odd, and stupid. Shoudln't do that. See what your version of excel does.
If it turns it into a morning time, we can add the "PM" back into the field you want, but I need to look up how do do that later- In the middle of something now. (it's called "concatenating") if you want to check the help menu.
Outpost Member #69.14159
"Raise your glass if you are wrong, in all the right ways
All my underdogs, we will never, never be
Anything but loud and nitty gritty, dirty little freaks"