Actually, when specifying unit="days" inside difftime() will do. -M
On Tue, Jul 10, 2012 at 3:55 PM, C W <tmrs...@gmail.com> wrote: > When the days and time are identical, difftime() gives difference in secs. > I still want difference in days. > > Say, below my last row is identical > dat3<-read.table(text=" > Begin_date End_date > 01JAN2000:00:00:00:000 02FEB2002:00:00:00:000 > 24MAR2012:00:00:00:000 18MAY2012:00:00:00:000 > 01OCT2003:00:00:00:000 02FEB2004:00:00:00:000 > 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 > 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 > 24DEC2012:00:00:00:000 24DEC2012:00:00:00:000 > ",sep="",header=TRUE) > > -M > > On Tue, Jul 10, 2012 at 1:52 PM, arun <smartpink...@yahoo.com> wrote: > >> Hi, >> >> Try this: >> >> dat3<-read.table(text=" >> Begin_date End_date >> 01JAN2000:00:00:00:000 02FEB2002:00:00:00:000 >> 24MAR2012:00:00:00:000 18MAY2012:00:00:00:000 >> 01OCT2003:00:00:00:000 02FEB2004:00:00:00:000 >> 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 >> 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 >> ",sep="",header=TRUE) >> >> dat3$Begin_date<-strptime(dat3[,1],format="%d%b%Y:%H:%M:%S") >> dat3$End_date<-strptime(dat3[,2],format="%d%b%Y:%H:%M:%S") >> >> difftime(dat3[,1],dat3[,2]) >> Time differences in days >> [1] -763.0000 -55.0000 -124.0417 -32.0000 -32.0000 >> attr(,"tzone") >> [1] "" >> >> A.K. >> >> ----- Original Message ----- >> From: C W <tmrs...@gmail.com> >> To: r-help <r-help@r-project.org> >> Cc: >> Sent: Tuesday, July 10, 2012 1:22 PM >> Subject: [R] calculating the difference between days? >> >> Hi List, >> >> I have one column of beginning dates and one column of ending dates, I >> want >> to find their difference. And I want to ignore the trailing zeros, >> basically everything after the first colon mark. >> >> Begin_date End_date >> 01JAN2000:00:00:00:000 02FEB2002:00:00:00:000 >> 24MAR2012:00:00:00:000 18MAY2012:00:00:00:000 >> 01OCT2003:00:00:00:000 02FEB2004:00:00:00:000 >> 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 >> 01JAN2000:00:00:00:000 02FEB2000:00:00:00:000 >> >> Thanks, >> >> Mike >> >> [[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.