I have a formula(text) field created that fetches only the time part of a date/time field.
Formula(Text) field: Time__c
However, upon sorting list view by that formula field, it does not display the expected result.
I've been clicking the ascend arrow but it always puts the record with 10:00 AM value first and always tops the 9:00 AM. Seems like it treats it as 1 and not as 10.
How could I sort this field properly?