I would like to know how to round five minutes to an hour and five minutes
after the hour to the nearest whole hour. (ex. round 7:55 and 8:05 to 8:00)

Thanks,

Ana

With a time in A1, this formula will round up or down to the nearest
hour:

=ROUND(A1*24,0)/24

However, this will round 7:31:00 up to 8:00:00 and 8:29:00 down to
8:00:00, which may not be what you want - if you have 7:50:00, do you
want this to stay as it is?

Pete


Ana wrote:
I would like to know how to round five minutes to an hour and five minutes
after the hour to the nearest whole hour. (ex. round 7:55 and 8:05 to 8:00)

Thanks,

Ana

See http://xldynamic.com/source/xld.Rounding.html#time

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Pete_UK" wrote in message
oups.com...
With a time in A1, this formula will round up or down to the nearest
hour:

=ROUND(A1*24,0)/24

However, this will round 7:31:00 up to 8:00:00 and 8:29:00 down to
8:00:00, which may not be what you want - if you have 7:50:00, do you
want this to stay as it is?

Pete


Ana wrote:
I would like to know how to round five minutes to an hour and five
minutes
after the hour to the nearest whole hour. (ex. round 7:55 and 8:05 to
8:00)

Thanks,

Ana