I have been given some data which needs some cleaning first. The issue I ham having is that the data time column supplied by the customer reads in as a character and any attempt to format this as Time results in JMP giving a null.
The date appear as "12/7/2011 6:57:20 AM" is there a way of making this into time format. Without hacking it via a script
This table was made by importing your CSV, then appending some duplicate 'PM' rows. The formula column converts the character date time to a JMP date time. There may be 'better' ways to do this, but a quick answer is usually good.