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

Peter Dalgaard BSA p.dalgaard at biostat.ku.dk
Mon Apr 29 23:28:10 CEST 2002


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

> The error in the seconds I am not concerned with.  The apparent error in the
> hr seems to be
> related to Daylight savings not accounted for Lotus 1-2-3.  For the range of
> data I will be
> working with I think I can fix the 1 day error problem but this fix will
> have problems between
> 1 and 36373.833.  Is there some exception to the leap year rule in the range
> 1900 to 1999 that
> would explain this discrepancy?

1900 was not a leap year, possibly Lotus has that wrong. The seconds
error could well be down to dealing in units of 1/1000th of a day =
86.4 seconds. The DST "error" might be better fixed by working in GMT
throughout. 


-- 
   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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list