[R] Comparing two times with different format

Duncan Mackay dulcalma at bigpond.com
Thu Jul 3 13:00:51 CEST 2014


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


Duncan Mackay
Department of Agronomy and Soil Science
University of New England
Armidale NSW 2351
Email: home: mackay at northnet.com.au

-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On
Behalf Of Marte Hansen
Sent: Thursday, 3 July 2014 18:33
To: r-help at 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 at r-project.org mailing list
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

More information about the R-help mailing list