Archive for August 30th, 2011

August 30, 2011

Convert Date-Time in Excel to POSIXct

This is an one-liner to convert a (numeric) date-time column from Excel to POSIXct:

rdatetime <- as.POSIXct( exceldatetime*24*3600 + as.POSIXct("1899-12-30 00:00") )

Advertisements