convertToDateTime: Convert from excel time number to R POSIXct type.
In awalker89/openxlsx: Read, Write and Edit XLSX Files
Description
Usage
Arguments
Details
Examples
Description
Convert from excel time number to R POSIXct type.
Usage
1
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
1
2
3
4
## 2014-07-01, 2014-06-30, 2014-06-29
x <- c(41821.8127314815, 41820.8127314815, NA, 41819, NaN)
convertToDateTime(x)
convertToDateTime(x, tx = "Australia/Perth")
awalker89/openxlsx documentation built on May 11, 2019, 4:09 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.
Description Usage Arguments Details Examples
Description
Convert from excel time number to R POSIXct type.
Usage
1 | 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
1 2 3 4 | ## 2014-07-01, 2014-06-30, 2014-06-29
x <- c(41821.8127314815, 41820.8127314815, NA, 41819, NaN)
convertToDateTime(x)
convertToDateTime(x, tx = "Australia/Perth")
|
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.