How do I sort such a format of Date Timestamp on Google Spreadsheet?-CodePudding

The image is the format of my Date Timestamp on gSpreadsheet. I have tried to sort it from earliest to latest date timestamp but it is not sorting well. Is there any ways to help me in this? Thank you, appreciate it.

CodePudding user response：

try:

=SORT(A2:A; INDEX(SPLIT(A2:A; ",");;1); 0; INDEX(SPLIT(A2:A; " ");;2), 0)

where you can change 0 (desc) to 1 (asc)

CodePudding user response：

Note!

You are using an invalid date format, time date should be a number and formated as date like so

To sort as is:

Use this formula

=QUERY(SORT({ A2:A, IF(A2:A="",,ArrayFormula(INDEX(ArrayFormula(SPLIT(SUBSTITUTE(A2:A,"GMT",""), ",")),,1) INDEX(ArrayFormula(SPLIT(SUBSTITUTE(A2:A,"GMT",""), ",")),,2)))}, 2,1), " Select Col1 ")