My Excel ('07) does not have a function that replicates scan() in SAS but here is how you could convert text times to numeric values in Excel, assuming the time data is in the rightmost column Use Data|Text to columns|Delimited|Space and tell it to skip the columns containing hours, minutes or seconds Formula =IF(ISBLANK(D5),TIME(0,B5,C5),TIME(B5,C5,D5))    -- adjust cells to the columns you want Times will show as fraction of a 24 hour day Copy the time column and paste special values into the next column Apply a 24 hour time format (shown as 13:30:55 in the list) Delete all intervening columns Richard in Oz ... View more

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. Richard in Oz ... View more