nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

666566_en-US

liliconcom

Data time format while importing excel sheet

Hello JMP users,

I am trying to import an excel sheet which have two different type date-time format. (screenshot attached below)

After importing in JMP format looks like below:

Can you suggest how to fix date-time format while importing excel sheet in to JMP table.

Thanks,

Data Blending and Cleanup

Re: Data time format while importing excel sheet

I would import the column as a character string, and then create a new formula column where the formula uses the distinction between the rows where the column has "/" vs. "-" to use the 2 different Informats, to input the two different date structures.

Re: Data time format while importing excel sheet

I concur with @txnelson.

Afterward, you can also check this discussion

https://community.jmp.com/t5/Discussions/Convert-Date-after-Import-file-from-Excel-Issue/m-p/653497

Comments

There are no comments yet