For example, if the data is 2-columns:
Peter 11:00am San Francisco
Paul 6:00pm Santa Clara
Mary 1:00pm San Jose
Can Google Sheets sort it by the time so that it is 11am, 1pm, and then 6pm?
Right now it will sort it as 1pm, 11am, and then 6pm.
If the data is 3-columns, then the sorting by time is as wanted, but if the data actually is given to me as 2-columns, then it won't work. So it seems solutions can be (1) sort it by human values, or not as good: (2) have another column which takes column 2 and filter out the time and therefore containing only the time, and sorting by this third column. But the sheet will have a redundant column this way.