excel dates and times in R
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.