Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Assuming the first column to contain text built from the first 8 places of time values formatted by "HH:MM:SS AM/PM" under a respective locale, a locale independent reconstruction of the correct time values as used by spreadsheets can be done this way:
=TIMEVALUE(IF(LEFT(A1;2)="12";SUBSTITUTE(A1;"12";"00";1);A1))+IF(B1="PM";1/2;0)
"Locale independent", of course, based on the column contents being in characters as descibed (ASCII conforming).

The results used for sorting will work independent of the displayed format then.