I am trying to sort a view of nodes using a text field with the time of day using the 12 hour clock as the sort criteria. Each node has one text field with a particular time in it. For example,
The trouble is, it doesn't sort them into any kind of order I can make sense of - let alone into chronological order as above.
Does anyone know if this is possible? How to achieve it?
Thanks for your help,