Date time stamp form excel failed

[#1]

Value original Excelfile format date-time:                     17.09.2021 10:37:24
Value after JMP-Import type STRING:                           44439,1151041667

Value JMP after correcting the type to date/time:  01.01.1904 12:20

That's a big problem and up to now I haven't found a solution. There are several columns with same issue.
It would be graet if somebody has a solution or tip.

[#2]

Remark:   During the JMP import all date-time columns are show correct in the preview

[#3]

That's strange, when I copy the date from the Excel-file and insert them into an empty datas sheet it works proper. So it seems to me like a JMP internal import problem.

[#4]

Hi @Mike_S,

I've tried to replicate this behavior with some simple examples in the attached excel file without success regardless of the import method chosen.  To help resolve this one, could you answer the following questions?

1. Can you import the attached file successfully? If you can, could you share a snippet of the time/date column you're having trouble with as an Excel file

2. What version of JMP are you running currently ?

[#5]

I assume that what you are seeing is the internal representation of an Excel date/time.  The integer portion of the value is the number of days since 01/01/1900 and the decimal portion is the proportion of the day( .25 is 6AM, .5 is 12 noon etc. ).  However, when I take 44439,1151041667 and feed it into Excel, I get 08/31/2021 02:45:45.  Is it possible you are showing the values from 2 different cells?

What version of JMP are you using, and what operating system?