Messy Date & Time String Reformatting

Have you tried the string to Date/Time conversion with this format which should cover AM and PM

dd/MM/yyyy hh.mm aa

I think the node can also auto guess the right format.

Also you can refer to.:

https://www.knime.com/blog/the-new-date-time-integration

I am not at my trusted machine right now so I can’t test it.