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: dulcalma@bigpond.com
> To: r-help@r-project.org; hansen_marte@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: mackay@northnet.com.au
> 
> -----Original Message-----
> From: r-help-bounces@r-project.org [mailto:r-help-bounces@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]]

