View Single Post
  #1   Report Post  
sheabones
 
Posts: n/a
Default 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