cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-802362%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EHow%20to%20export%20time%20format%20from%20Excel%20to%20JMP%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802362%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20time%20format%2C%20mm-dd-yyyy%20hh%3Amm%3Ass%2C%20on%20excel.%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20JMP%2C%20it%20only%20shows%20mm-dd-yy%20format.%20I%20changed%20the%20format%20to%20m-d-y%20h%3Am%3As%20on%20'column%20info'.%3C%2FP%3E%3CP%3EStill%20only%20mm-dd-yy%20appears%20on%20JMP.%3C%2FP%3E%3CP%3ECould%20someone%20please%20help%20me%20with%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-802362%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3EData%20Blending%20and%20Cleanup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-802446%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20How%20to%20export%20time%20format%20from%20Excel%20to%20JMP%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802446%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EWhich%20JMP%20version%20are%20you%20using%3F%20Are%20you%20using%20excel%20wizard%20to%20load%20the%20data%20into%20JMP%3F%20Can%20you%20share%20a%20small%20example%20excel%20file%20which%20can%20be%20used%20to%20replicate%20the%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803051%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20How%20to%20export%20time%20format%20from%20Excel%20to%20JMP%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803051%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EOh%20i%20did%20not%20meant%20to%20accept%20as%20a%20solution%20but%20I%20use%20JMP%20Pro%2017%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
joepark
Level III

How to export time format from Excel to JMP?

Hello,

 

I have time format, mm-dd-yyyy hh:mm:ss, on excel. 

On JMP, it only shows mm-dd-yy format. I changed the format to m-d-y h:m:s on 'column info'.

Still only mm-dd-yy appears on JMP.

Could someone please help me with this?

 

Thank you

2 REPLIES 2
jthi
Super User

Re: How to export time format from Excel to JMP?

Which JMP version are you using? Are you using excel wizard to load the data into JMP? Can you share a small example excel file which can be used to replicate the issue?

-Jarmo
joepark
Level III

Re: How to export time format from Excel to JMP?

Oh i did not meant to accept as a solution but I use JMP Pro 17