724546_en-US

liliconcom

Times from Excel

Hey, when I pull in a time from excel I get a number like  `-126167045`.  So when I try to add it to date, it gives a very weird number.  

I can get around this by turning it to a string and back into a number, but that seems weird.  Anyone know what's going on and if there's a better way than

:Date + Num( Format( :Time, "h:m:s" ) )

Automation and ScriptingRe: Times from Excel

Hi @vince_faller ,

 

  A few questions so that I can try and recreate the issue you're having:

 

1. Do you have some time data you can share?

2. When you pull in the data, are you using JSL to Open() the excel file and bring it in?

3. Or are you using the JMP add-in for excel to generate the data table from excel?

4. What is the time format in excel (h:m:s?, h:m?, etc.) and how is it formatted in excel (ctrl+1)?

5. What is you're operating system's time settings? I've come across problems where importing European number formats (comma as a decimal separator), JMP will treat it as nominal and not as a number. Changing the system settings can get around this -- or vice versa cause issues.

 

Thanks!,

DS

Re: Times from Excel

Names default to here(1);
New Table("Example",
	<< New Column("Date", <<FORMAT></FORMAT>

 

Just pulling in the attached data via. 

dt = open("$DESKTOP/thiny.xlsx");
show(dt:Time[1])