I am having the same problem. I've spent nearly the whole morning trying to convert M/D/YYYY h:mm:ss AM/PM data to D/M/YYYY h:mm:ss. I've converted the downloaded and unzipped file from csv to xlsx format, but I can't change those date and time values from General values to the date and time format I want to work with. Also, as mentioned, there are blocks of data with different formats: very time consuming and VERY frustrating!
