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:
"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.