At the expense of extra bandwidth
Remember Excel is a workbook or worksheet not a database caveat emptor or such ilk Duncan From: Marte Hansen [mailto:hansen_ma...@hotmail.com] Sent: Thursday, 3 July 2014 22:06 To: Duncan Mackay; R Subject: RE: [R] Comparing two times with different format Fine bug that Excel provides. I had hoped that it would not require editing in Excel, but... It works now! Thank you so much! > From: dulca...@bigpond.com > To: r-help@r-project.org; hansen_ma...@hotmail.com > Subject: RE: [R] Comparing two times with different format > Date: Thu, 3 Jul 2014 21:00:51 +1000 > > 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. > [[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.
