- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Time durations with milliseconds - custom Format pattern
I was not able to come up with a Format Pattern that worked, however, the following simple script works
For Each Row(
If( Contains( :column 1, ":" ),
:column 1 = Char(
Num( Word( 1, :column 1, ":" ) ) * 60 + Num( Word( 2, :column 1, ":" ) )
)
)
);
:column 1 << data type( numeric ) << modeling type( continuous );
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Time durations with milliseconds - custom Format pattern
If you had "properly" formatted data JMP could handle this (those rows which have no minutes should have 0: at the start). Column 3 is a copy of Column 2 with format pattern applied with three decimals
I think you have to create formula to convert your strings to either directly to seconds or to some format which JMP could understand