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%3E%C2%BFC%C3%B3mo%20exportar%20el%20formato%20de%20hora%20de%20Excel%20a%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%3EHola%2C%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3ETengo%20el%20formato%20de%20hora%2C%20mm-dd-aaaa%20hh%3Amm%3Ass%2C%20en%20Excel.%3C%2FP%3E%3CP%3EEn%20JMP%2C%20solo%20se%20muestra%20el%20formato%20mm-dd-aa.%20Cambi%C3%A9%20el%20formato%20a%20mda%20h%3Am%3As%20en%20%22informaci%C3%B3n%20de%20columna%22.%3C%2FP%3E%3CP%3ETodav%C3%ADa%20s%C3%B3lo%20aparece%20mm-dd-aa%20en%20JMP.%3C%2FP%3E%3CP%3E%C2%BFPodr%C3%ADa%20alguien%20ayudarme%20con%20esto%20por%20favor%3F%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3EGracias%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%3ECombinaci%C3%B3n%20y%20limpieza%20de%20datos%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%20%C2%BFC%C3%B3mo%20exportar%20el%20formato%20de%20hora%20de%20Excel%20a%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%3E%C2%BFQu%C3%A9%20versi%C3%B3n%20de%20JMP%20est%C3%A1s%20usando%3F%20%C2%BFEst%C3%A1s%20usando%20el%20asistente%20de%20Excel%20para%20cargar%20los%20datos%20en%20JMP%3F%20%C2%BFPuedes%20compartir%20un%20peque%C3%B1o%20archivo%20de%20Excel%20de%20ejemplo%20que%20se%20pueda%20usar%20para%20replicar%20el%20problema%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%20%C2%BFC%C3%B3mo%20exportar%20el%20formato%20de%20hora%20de%20Excel%20a%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%2C%20no%20quise%20aceptarlo%20como%20soluci%C3%B3n%2C%20pero%20uso%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