cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
TONG_SUPER
New Member

MM/DD HH:MM conversion how to do

I have a time Colum in a odd format  ( do not even have Year in and  need help converting to a simply   YY/MM/DD HH:MM

Thanks

 

tong

 

Time
[08/06-19:07:34.981]
[08/06-19:08:05.927]
[08/06-19:08:14.270]
[08/06-19:08:26.331]
1 REPLY 1
txnelson
Super User

Re: MM/DD HH:MM conversion how to do

Here is the formula I used to do the conversion

Date MDY( Num( Word( 1, :Time, "[/" ) ), Num( Word( 2, :Time, "[/-" ) ), 2024 )
+Informat( Word( 3, :Time, "[/-]" ), "hh:mm:ss" )

txnelson_0-1724716233316.png

 

Jim