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