Is there an easy way to put in times (i.e. 18 minutes 30 seconds) into a data table and have JMP recognize them as numbers rather than categories? I have an excel spreadsheet with all the data, and would ideally cut and paste it over to JMP. Plan B would be to just manually enter the data, but I do not know how to work around doing out the math from minutes to seconds for every entry. Any suggestions? For those who are interested, my overall goal is to put together a spreadsheet of Cross-Country race times on different courses and use ANOVA to see what courses are faster/slower.
I don't currently have access to JMP but a start might be to convert the times into a standard time notation in Excel, eg 00:18:30. Then when you import the data into JMP it should appear as a numeric variable.