Learn R Programming

openxlsx (version 4.2.6.1)

convertToDateTime: 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

Run this code
## 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