If the data was HH:MM instead of HH.MM excel would automagically format the cell as time.

You'd still have to convert them to 24hr time to get it to sort correctly though