Formatting date/times issue

[jamiek]

Hi,

I am trying to sort orders by date/time within the CSV export from my order system, however when I try to sort it does the dates correctly, but not the times (hour/minute).

How can I make it so the sort works for the hour/minute as well? I tried changing the formatting to see if that would help but for some reason no matter what formatting I select, the formatting doesn't actually change the text displayed in the cells.

Please see image below.

Link to CSV file on Google Drive here link to CSV

Would love some help

Thanks

 

[jamiek]

Amazing! Thanks Dave.

I think I'll go for the VBA option as I'll need to be doing this every day ?

 

[Dave Patton]

Thanks for the feedback.
Dave