Rounding Data Question

S

sheabones

I have an excel sheet made for my employees. I want them to enter thei
hours in the cells that are unlocked and then have that number the
entered to be rounded to the nearest 0.5 hour. Many of them seem t
have trouble rounding, so it saves the hastle.

How do I create a function or use a function that allows them to ente
in a number, then rounds it automatically?

Thanks for the hel
 
R

Ron Rosenfeld

I have an excel sheet made for my employees. I want them to enter their
hours in the cells that are unlocked and then have that number they
entered to be rounded to the nearest 0.5 hour. Many of them seem to
have trouble rounding, so it saves the hastle.

How do I create a function or use a function that allows them to enter
in a number, then rounds it automatically?

Thanks for the help
Click to expand...

=ROUND(A1/TIME(0,30,0),0)*TIME(0,30,0)




--ron
 
Top