One useful package is "chron":
example:
library(chron)
#convert excel time to date time format
etime = 39965.0004549653
orig =chron("12/30/1899"); # "origin" of excel time.
date.time = orig + etime;
substr(as.character(date.time), 2, 18) # as character without parentheses.
HTH,
Ken
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
