powered by
Convert from excel time number to R POSIXct type.
convertToDateTime(x, origin = "1900-01-01", ...)
A numeric vector
date. Default value is for Windows Excel 2010
Additional parameters passed to as.POSIXct
Excel stores dates as number of days from some origin date
## 2014-07-01, 2014-06-30, 2014-06-29 x <- c(41821.8127314815, 41820.8127314815, NA, 41819, NaN) convertToDateTime(x) convertToDateTime(x, tz = "Australia/Perth") convertToDateTime(x, tz = "UTC")
Run the code above in your browser using DataLab