Hi If you have problems with dates in Excel copy and paste the date column into a text editor and see if there are any peculiarities.
Remember what is shown on the screen may be totally different from what is stored. Duncan Duncan Mackay Department of Agronomy and Soil Science University of New England Armidale NSW 2351 Email: home: mac...@northnet.com.au -----Original Message----- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Marte Hansen Sent: Thursday, 3 July 2014 18:33 To: r-help@r-project.org Subject: [R] Comparing two times with different format I want to compare two tables, but the format on the time stamps are different. Both had the same format in Excel, but when I read those into R, the times have changed in the following way: 00:00 = 0:00, that is, the smallest dataset has the original time stamp, the largest has a new format. The two dataset are pretty big, about 65 000 rows on the smallest and 350 000 rows in the largest... So changing them manually is not an option. They are read in the same, so I don't understand how one of them changes the format on one column. Hist <- read.xls(HistFil, perl = perl, header = FALSE, colClasses = c( rep("character", 7))) Ra <- read.xls(RaFil, perl = perl, header = TRUE, colClasses = c(rep("character", 6))) [[alternative HTML version deleted]] ______________________________________________ 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.