Need help sorting by time

[maym]

Hi

I have a spreadsheet that I am trying to sort by time. The times are all in text format. How can I get excel to sort by time? In the attached sample, it works until the last row (I have highlighted it). 12.35pm should come before the rest, but excel places it after 1,2,3,pm etc.?

Thanks

[José Augusto]

Try this approach
In Cell E2 use the following formula

Please Login or Register  to view this content.

Sort the table by this column.
See the file

[maym]

thanks Jose, that has done it

[José Augusto]

You are welcome.