rounding times to the nearest hour in R

user1558387 picture user1558387 · May 8, 2013 · Viewed 12.4k times · Source

I have data in the format

time <-  c("16:53", "10:57", "11:58")

etc

I would like to create a new column where each of these times is rounded to the nearest hour. I cannot seem to get the POSIX command to work for me.

as.character(format(data2$time, "%H:%M"))

Error in format.default(structure(as.character(x), names = names(x), dim = dim(x), : invalid 'trim' argument

Let alone use the round command. Can anyone advise?

Answer

Josh O&#39;Brien picture Josh O'Brien · May 8, 2013
## Example times
x <- c("16:53", "10:57", "11:58")

## POSIX*t objects need both date and time specified
## Here, the particular date doesn't matter -- just that there is one.
tt <- strptime(paste("2001-01-01", x), format="%Y-%m-%d %H:%M")

## Use round.Date to round, then format to format
format(round(tt, units="hours"), format="%H:%M")
# [1] "17:00" "11:00" "12:00"