View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bill999 bill999 is offline
external usenet poster
 
Posts: 3
Default Date and time but date not wanted

Hi I have a column with dates and time in each cell. E.g. 13/08/07 9.31.13

the problem I have is, I want to sort the column in time order only not date
and time.

E.g

13/08/07 9.31.13
14/08/07 08.12.15
15/08/07 07.31.13

I want it to sort so that it ignores date and looks like this

7.31.13
8.12.15
9.31.13

Any help appreciated as I do not have a clue. If this is not clear please ask.

Thanks Bill
Edit/Delete Message