@Sciguy_1 ,
Attached is a table with the formula to do the conversion.
![image.png image.png](https://community.jmp.com/t5/image/serverpage/image-id/17484i5F300227AE42AD13/image-size/large?v=v2&px=999)
The format is min:s with 4 decimal places, or if you prefer 1 decimal you will see 0:01.9
The internet has many sources regarding conversion of date and time to numeric values. Excel stores time as a fraction of a day. See link.
When Excel is read into JMP, the numeric stored value is read-in. So to convert that to min:s you need to create a new column that multiplies the read-in value by 86400 and change that formula column's format to min:s
I had to look it up as well. Nice to know.