[R] Lotos 1-2-3 date to POSIXct

[Peter Dalgaard BSA]

"Moffet, Corey" <Corey.Moffet at ttu.edu> writes:

> I have some data that was created for import into a Lotus 1-2-3 spreadsheet
> and on of the columns is time.  The
> time is akin to Julian were the value 1 is mapped "01-Jan-00 12:00:00 AM" in
> Lotus 1-2-3.  Is there a function in an R package that can convert this
> numeric vector to a POSIXct vector?

Units are seconds? Subtract 1 and add "01-Jan-00 12:00:00 AM" using
ISOdate. Otherwise convert units, cf:

> ISOdate(2000,1,1)+2000*24*60*60 # 2000 days after the Millennium
[1] "2005-06-23 14:00:00 MET DST" 


-- 
   O__  ---- Peter Dalgaard             Blegdamsvej 3  
  c/ /'_ --- Dept. of Biostatistics     2200 Cph. N   
 (*) \(*) -- University of Copenhagen   Denmark      Ph: (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)             FAX: (+45) 35327907
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._