Rapidminer displays certain times wrong after Excel import
Dear Rapidminer Community,
it's me again, yet with another problem
This time I am importing data from an Excel into Rapidminer which contains dates in the format dd/mm/yyyy hh:mm. Most of the imports are correct but the software makes one mistake which is crucial for me.
Lets say I have a time in my excel: 23.10.2017 00:00 (which is for me midnight), Rapidminer imports this time stamp as: 23.10.2017 12:00AM. Shouldn't it rather be 12:00PM or 00:00AM? I am not a US citizen but I think 12:00 AM is definitely wrong if I want to have the midnight time, right?
How can I fix this problem? With a "date to nominal" operator and than somehow convert it again?