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
Sort by:
1 - 1 of 11
    User: "BalazsBaranyRM"
    BalazsBaranyRM
    New Altair Community Member
    Accepted Answer

    Hi!

     

    This is just an artefact of the time format used by RapidMiner. 

    12:00:00 AM is actually 00:00:00 in 24 hour format. You can easily check this by using Date to Nominal. Your timestamps are correct, they are just displayed in an unusual (to you and me) way. 

     

    I would also prefer if RapidMiner used the ISO time format (yyyy-MM-dd HH:mm:ss) for display.

     

    Regards,

    Balázs

    View in context
Quick Links