=ROUND(A1*24,0)/24

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Sanch" wrote in message
oups.com...
I am working on a time sheet that I need to tweak slightly, currently
I have a time in and time out log:

In: 6:58
Out 17:36

I am trying to round these numbers to the nearest hour 6:58 to 7am,
however 17:36 needs to round down to 17:00. The formula I am curently
using is: =TIME(HOUR(B9),MROUND(MINUTE(B9),$M$1),0) The M references
the rounding #. It is currently set at 60.

Scott