Rounding Data Question
 

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


--
sheabones
------------------------------------------------------------------------
sheabones's Profile: http://www.excelforum.com/member.php...o&userid=27674
View this thread: http://www.excelforum.com/showthread...hreadid=471873

On Thu, 29 Sep 2005 13:48:12 -0500, sheabones
wrote:


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

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




--ron