dtt_excel_to_date_time {dttr2} | R Documentation |
Convert Excel date times to date times.
Description
Converts Excel serial date times to date time class.
Usage
dtt_excel_to_date_time(x, tz = dtt_default_tz(), modern = TRUE, ...)
Arguments
x |
A vector of numbers to convert. |
tz |
A string of the time zone. |
modern |
A flag specifying whether to use the modern or old Excel date system. |
... |
Unused. |
Details
Defaults to the modern Excel date encoding system. Excel for Mac 2008 and earlier Mac versions of Excel use a different date system. If the date 2016-01-01 is represented by 42370, it's the modern system. If it's 40908, it's the old system.
Value
A floored POSIXct vector.
Examples
dtt_excel_to_date_time(42370.1234)
dtt_excel_to_date_time(c(1000.1145, 43397.84578))
dtt_excel_to_date_time(45324.1234, tz = "UTC")
dtt_excel_to_date_time(42370.1234, modern = FALSE)
[Package dttr2 version 0.5.0 Index]