rounding times to the nearest hour in R

14,130
## 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"
Share:
14,130
user1558387
Author by

user1558387

Updated on June 27, 2022

Comments

  • user1558387
    user1558387 almost 2 years

    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?