im having some issues in converting the data in a csv data set. when i click on the cell it shows this format: 8/23/2018 6:40:00 PM, but when im not clicking on it its on the format 8/23/2018 18:40. i want to convert it in R language for a time series visualization, im using this code but it does not convert it, makes all the cells NA.

the code is: crimes2018$ACTUAL_DTE <- as.Date(crimes2018$ACTUAL_DTE, format = "%d/%m/%Y %H:%M %p")

Any suggestions?