openxlsx can not convert date/time serial numbers

Question

openxlsx can not convert date/time serial numbers

Closed this issue 2 months ago · 2 comments

when reading an excel file with date & time the detectDates = TRUE does not convert the date/time serial number. the worst part is that it truncates the numbest so when using Date.Time = as.POSIXct("df.reference", origin = "2015-10-29") the date is correct but the %H:%M:%S are incorrect.

Answer 1 · 2024-05-11T01:59:57.000Z

This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.

Answer 2 · 2024-05-18T02:02:26.000Z

This issue was closed because it has been stalled for 7 days with no activity.