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 );
![txnelson_0-1697892266545.png txnelson_0-1697892266545.png](https://community.jmp.com/t5/image/serverpage/image-id/57873i1A4DF9D361B840C1/image-size/medium?v=v2&px=400)
Jim