689143_en-US

liliconcom

Time durations with milliseconds - custom Format pattern

Hello,

 

Any suggestion how to use custom Format pattern for time or duration format in the following scenario? As example, I have following data imported (as character):

 

42.336

51.858

01:17.9

 

This data should be understood as time durations in format mm:ss.000. I would like to have advices how to get data above to be shown as in (numeric) format ss.000 like below

 

42.336

51.858

77.900

 

or alternatevily in numeric time format

 

0:42.336

0:51.858

1:17.900

 

I hope that this can be done without any scripting. Any advices are highly appreciated! I am running JMP 16.2

Basic Data Analysis and Modeling