cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-802362%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EExcel%EC%97%90%EC%84%9C%20JMP%EB%A1%9C%20%EC%8B%9C%EA%B0%84%20%ED%98%95%EC%8B%9D%EC%9D%84%20%EB%82%B4%EB%B3%B4%EB%82%B4%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%80%20%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-802362%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%EC%95%88%EB%85%95%ED%95%98%EC%84%B8%EC%9A%94%2C%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%EC%97%91%EC%85%80%EC%97%90%EC%84%9C%EB%8A%94%20%EC%8B%9C%EA%B0%84%20%ED%98%95%EC%8B%9D%EC%9D%84%20mm-dd-yyyy%20hh%3Amm%3Ass%EB%A1%9C%20%EC%82%AC%EC%9A%A9%ED%95%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3EJMP%EC%97%90%EC%84%9C%EB%8A%94%20mm-dd-yy%20%ED%98%95%EC%8B%9D%EB%A7%8C%20%EB%B3%B4%EC%97%AC%EC%A4%8D%EB%8B%88%EB%8B%A4.%20'column%20info'%EC%97%90%EC%84%9C%20%ED%98%95%EC%8B%9D%EC%9D%84%20mdy%20h%3Am%3As%EB%A1%9C%20%EB%B3%80%EA%B2%BD%ED%96%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3EJMP%EC%97%90%EC%84%9C%EB%8A%94%20%EC%95%84%EC%A7%81%EB%8F%84%20mm-dd-yy%EB%A7%8C%20%EB%82%98%ED%83%80%EB%82%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%EB%88%84%EA%B5%AC%EB%93%A0%EC%A7%80%20%EC%9D%B4%EA%B2%83%EC%97%90%20%EB%8C%80%ED%95%B4%20%EB%8F%84%EC%99%80%EC%A3%BC%EC%8B%A4%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%EA%B0%90%EC%82%AC%ED%95%A9%EB%8B%88%EB%8B%A4%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%3E%EB%8D%B0%EC%9D%B4%ED%84%B0%20%EB%B8%94%EB%A0%8C%EB%94%A9%20%EB%B0%8F%20%EC%A0%95%EB%A6%AC%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%20Excel%EC%97%90%EC%84%9C%20JMP%EB%A1%9C%20%EC%8B%9C%EA%B0%84%20%ED%98%95%EC%8B%9D%EC%9D%84%20%EB%82%B4%EB%B3%B4%EB%82%B4%EB%8A%94%20%EB%B0%A9%EB%B2%95%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%EC%96%B4%EB%96%A4%20JMP%20%EB%B2%84%EC%A0%84%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EA%B3%A0%20%EA%B3%84%EC%8B%A0%EA%B0%80%EC%9A%94%3F%20Excel%20Wizard%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20JMP%EC%97%90%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20%EB%A1%9C%EB%93%9C%ED%95%98%EA%B3%A0%20%EA%B3%84%EC%8B%A0%EA%B0%80%EC%9A%94%3F%20%EB%AC%B8%EC%A0%9C%EB%A5%BC%20%EC%9E%AC%ED%98%84%ED%95%98%EB%8A%94%20%EB%8D%B0%20%EC%82%AC%EC%9A%A9%ED%95%A0%20%EC%88%98%20%EC%9E%88%EB%8A%94%20%EC%9E%91%EC%9D%80%20%EC%98%88%EC%A0%9C%20Excel%20%ED%8C%8C%EC%9D%BC%EC%9D%84%20%EA%B3%B5%EC%9C%A0%ED%95%B4%20%EC%A3%BC%EC%8B%A4%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%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%20Excel%EC%97%90%EC%84%9C%20JMP%EB%A1%9C%20%EC%8B%9C%EA%B0%84%20%ED%98%95%EC%8B%9D%EC%9D%84%20%EB%82%B4%EB%B3%B4%EB%82%B4%EB%8A%94%20%EB%B0%A9%EB%B2%95%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803051%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%EC%95%84%2C%20%ED%95%B4%EA%B2%B0%EC%B1%85%EC%9C%BC%EB%A1%9C%20%EB%B0%9B%EC%95%84%EB%93%A4%EC%9D%B4%EB%A0%A4%EA%B3%A0%20%ED%95%9C%20%EA%B1%B4%20%EC%95%84%EB%8B%88%EC%A7%80%EB%A7%8C%20JMP%20Pro%2017%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%B4%EC%9A%94.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
joepark
joepark
Level III

How to export time format from Excel to JMP?

Sep 27, 2024 03:21 PM (412 views)

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

0 Kudos
2 REPLIES 2
jthi
Super User jthi
Super User

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

Sep 28, 2024 01:08 AM (380 views)  |  Posted in reply to message from joepark 09-27-2024

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
0 Kudos
joepark
joepark
Level III

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

Oct 1, 2024 03:21 PM (331 views)  |  Posted in reply to message from jthi 09-28-2024

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

0 Kudos