Hi how do I import an excel file with date and time information?
Loco
New Altair Community Member
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
-
The spreadsheet is preserving the data in its original format when saved and the cell format is loaded separately after that.
5
Altair EmployeeAnswers
-
The spreadsheet is preserving the data in its original format when saved and the cell format is loaded separately after that.
5 -
Hi guys, this is very useful indeed. I used Scott's method and got it to work.. using the nomial to date converter
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!0 -
Lesson learnt : Easier to get the format sorted at the source, i.e. the excel file to avoid conversions.. cheers1