I think that isn't really a time but rather date with time (not sure why JMP is pulling it in like that though and not adjusting it). And other issue is that for whatever reason the time is negative even if you use Time Of Day function (most likely just because Excel's date starts from 1.1.1900 and JMPs from 1.11904).
You could perform the conversion like this (Time3 column)
Names Default To Here(1);
dt = Open("$DOWNLOADS/thiny.xlsx");
Column(dt, "Time") << Format("Format Pattern", "<YYYY><-><MM><-><DD><'T'><hh24><::><mm><::><ss>", 19, 0);
// In Hours(16) + In Minutes(34) + 31;
// -26729.2820000052? negative value for time of day
dt << New Column("Time2", Numeric, Continuous, Format("h:m:s", 11, 0), Formula(
Time Of Day(:Time) // negative?
));
dt << New Column("Time3", Numeric, Continuous, Format("h:m:s", 11, 0), Formula(
If(:Time < 1,
In Hours(24) + Time Of Day(:Time)
,
Time Of Day(:Time)
);
));
dt << New Column("DateTime", Numeric, Continuous,
Format("Format Pattern", "<YYYY><-><MM><-><DD><'T'><hh24><::><mm><::><ss>", 19, 0),
Formula(:Date + :Time3)
);
First check if time of day is negative and if it is, then deduct it from the seconds in single day to get "correct" time for dates after 1.1.1904.
This might be necessary but I'm not sure how to feel about this
New Table("Sheet1 2",
Add Rows(1),
Compress File When Saved(1),
New Column("Date",
Numeric,
"Continuous",
Format("Format Pattern", "<D> <MMM> <YYYY>", 12),
Input Format("Format Pattern", "<D> <MMM> <YYYY>"),
Set Values([3790540800])
),
New Column("Time",
Numeric,
"Continuous",
Format("Format Pattern", "<YYYY><-><MM><-><DD><'T'><hh24><::><mm><::><ss>", 19, 0),
Input Format("Format Pattern", "<hh><:><mm><:><ss> <ampm>", 0),
Set Values([-126170729.282]),
Set Display Width(146)
),
New Column("Time2Time", Numeric, "Continuous", Format("h:m:s", 12, 0), Input Format("h:m:s", 0), Set Values([-26729.2820000052])),
New Column("Time2Best", Numeric, "Continuous", Format("Best", 11), Formula(Time Of Day(:Time))),
New Column("Time3Time", Numeric, "Continuous", Format("h:m:s", 11, 0), Input Format("h:m:s", 0), Set Values([59670.7179999948])),
New Column("Time3Best", Numeric, "Continuous", Format("Best", 11), Formula(If(:Time < 1, In Hours(24) + Time Of Day(:Time), Time Of Day(:Time))))
)
-Jarmo