🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Rapidminer displays certain times wrong after Excel import

User: "felix_w"
felix_w
New Altair Community Member
Updated by Jocelyn

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?

Find more posts tagged with

AI Studio
Excel
Quick Links