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.