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
Choose Language Hide Translation Bar
joepark
joepark
Level III

How to export time format from Excel to JMP?

Sep 27, 2024 03:21 PM (414 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 (382 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 (333 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