On Mon, Dec 8, 2008 at 11:52 PM, Tubin <sredmonson at yahoo.com>
wrote:>
> I have date and time data which looks like this:
>
> [,1] [,2]
> [1,] "7/1/08" "9:19"
> [2,] "7/1/08" "9:58"
> [3,] "7/7/08" "15:47"
> [4,] "7/8/08" "10:03"
> [5,] "7/8/08" "10:32"
> [6,] "7/8/08" "15:22"
> [7,] "7/8/08" "15:27"
> [8,] "7/8/08" "15:40"
> [9,] "7/9/08" "10:25"
> [10,] "7/9/08" "10:27"
>
> I would like to use chron on it, so that I can calculate intervals in time.
>
> I can't seem to get chron to accept the time format that doesn't
include
> seconds. Do I have to go through and append :00 on every line in order to
> use chron?
That's one way:
m <- matrix( c("7/1/08","9:19",
"7/1/08","9:58",
"7/7/08","15:47",
"7/8/08","10:03",
"7/8/08","10:32",
"7/8/08","15:22",
"7/8/08","15:27",
"7/8/08","15:40",
"7/9/08","10:25",
"7/9/08","10:27"), nc = 2, byrow = TRUE)
chron(m[,1], paste(m[,2], 0, sep = ":"))
# another is to use as.chron
as.chron(apply(m, 1, paste, collapse = " "), "%m/%d/%y
%H:%M")