Right import format for columns
I’m trying to import StudyHour Data inside Rapidminer, which shows the number of hours someone studied a day.
The issue is that it converts into time as what time it is (pm/am) but I’m trying to get hours as the amount of time passed while studying. Not the actual time.
I used the type “hh:mm” in excel as you can see in the picture. I thought that’s the right type but it turns into am/pm hours.
What do I have to do to get it as it is shown in Excel? Do I have to change the type in Excel or do I have to change something in Rapidminer?
Thanks in advance,