openxlsx (version 2.2.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 = "1970-1-1")

Arguments

x

A numeric vector

origin

date. Default value is for Windows Excel 2010

Details

Excel stores dates as number of days from some origin day (this origin is "1970-1-1" for Excel 2010).

Examples

## 2014-07-01 & 2014-06-30
x <- c(41821.8127314815, 41820.8127314815)
convertToDateTime(x)