Thread: Sort times.
View Single Post
  #6  
Old 27th July 2015, 08:03 AM
jazzy jazzy is offline
Member
  
Join Date: Nov 2010
Posts: 49
Default
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
Reply With Quote