Re: [R] Help: From Excel date to R-date!

2010-10-21 Thread Gabor Grothendieck
On Thu, Oct 21, 2010 at 1:31 PM, Amy Young-King wrote: > Hi all, > > I am really new to dealing with Excel date and time formats to be used in R. > > I have an Excel exported data matrix in TXT format. > > One column, labeled DATE, is of the following format examples: > > > 1/8/98 1:00 > 1/8/98 23

Re: [R] Help: From Excel date to R-date!

2010-10-21 Thread Prof Brian Ripley
If those are the only formats and the dates are in the current timezone ... dates <- c("1/8/98 1:00", "1/8/98 23:00") as.POSIXct(dates, format = "%d/%m/%y %H:%M") [1] "1998-08-01 01:00:00" "1998-08-01 23:00:00" As for how to handle such a time series in R, it depends if it is a regular or ir

[R] Help: From Excel date to R-date!

2010-10-21 Thread Amy Young-King
Hi all, I am really new to dealing with Excel date and time formats to be used in R. I have an Excel exported data matrix in TXT format. One column, labeled DATE, is of the following format examples: 1/8/98 1:00 1/8/98 23:00 to mean that the observation was made on 1st of August 1998 at 1AM