DateTime from Excel Cell ExcelApplication MSOfficeAutomation

Hi Markus,

I believe there are different ways that time is formatted in Excel compared to Xojo.

Excel saves a data and time as a serial number such as (42441.482088). The numbers to the left of the decimal point are the number of days since 1 January 1900, and the numbers to the right is the percent of the day which has passed (48.2088 % of the day has passed).

There is more information in the following forum link: Excel date number

Happy to help

1 Like