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@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.
______________________________________________
R-help@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.
