convertToDateTime: Convert from excel time number to R POSIXct type.
In openxlsx: Read, Write and Edit xlsx Files
convertToDateTime R Documentation
Convert from excel time number to R POSIXct type.
Description
Convert from excel time number to R POSIXct type.
Usage
convertToDateTime(x, origin = "1900-01-01", ...)
Arguments
x
A numeric vector
origin
date. Default value is for Windows Excel 2010
...
Additional parameters passed to as.POSIXct
Details
Excel stores dates as number of days from some origin date
Examples
## 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")
openxlsx documentation built on Feb. 16, 2023, 6:47 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
| convertToDateTime | R Documentation |
Convert from excel time number to R POSIXct type.
Description
Convert from excel time number to R POSIXct type.
Usage
convertToDateTime(x, origin = "1900-01-01", ...)
Arguments
x |
A numeric vector |
origin |
date. Default value is for Windows Excel 2010 |
... |
Additional parameters passed to as.POSIXct |
Details
Excel stores dates as number of days from some origin date
Examples
## 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")
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.