LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Data question RPIJG Excel Worksheet Functions 1 August 19th 05 07:47 PM
Another Exciting Data Table Question!!!! xinekite Charts and Charting in Excel 1 May 29th 05 01:22 PM
Control Box Data Question camerons New Users to Excel 2 April 26th 05 03:33 AM
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Data Table Question SmokyMtnzz Charts and Charting in Excel 3 December 6th 04 05:48 PM


All times are GMT +1. The time now is 07:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"