Options
Hi how do I import an excel file with date and time information?
Newbie
I have an excel table showing activities that were performed on various dates and time.. in the excel file do I import these as 2 separate columns and can the format be dd/MM/YYYY and time HH:MM.. or must it be in one column, i.e. dd/MM/YYYY@HH:MM.. I tried this single column but the import process re-set the time info to 12:00
Tagged:
0
Best Answers
-
Options
sgenzer
Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 
Community Manager
hi @Loco if it were me, I'd import that date time column from Excel as a nominal attribute, and then convert it afterwards using "Nominal to Date".
Scott
5 -
Options
Roge1r
Member Posts: 1 
Contributor I
The spreadsheet is preserving the data in its original format when saved and the cell format is loaded separately after that.
5
Answers
Acting on a hint from Roger's post, I actually spent some time to get an appropriate format, i.e. dd/MM/yyyy Hh:mm and I found that I did not even need to do any conversion, on importing the rapidminer software auto-detected it to be a date and time and it works fine
Thank u so much! Now I can finally get to analysing the stuff... cheers!