[R] excel dates and times in R

[Jannis]

Well, strptime is certainly the way to go. You did not provide any 
reproducible example so i can just roughly point out the way to go:

1: combine the two colums to one with paste(,collapse='_')
2: strptime() with the corresponding formats (like "%d-%b-%Y_%H:%M:%S" 
or similar)


HTH
Jannis

On 08/05/2011 12:27 PM, bevare wrote:
> Hello,
>
> I am having some fun dealing with dates and times. My input is a excel csv
> file with two columns with data in the following format:
>
> date                                   time
> 25-Jun-1961                       04:00:00
>
> i.e. day - month - year       hour:min:sec
>
> I would like to have a single object in R that combines these and converts
> them into a sensible R format (e.g.
> ISOdatetime(1961,06,25,04,00,00,tz="GMT").
>
> I have played with the function chron and also strptime but can't seem to
> get them to work.
>
> Can anybody help me out please?
>
> Thanks
>
> Bevare
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/excel-dates-and-times-in-R-tp3720887p3720887.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at r-project.org 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.
>