Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-27-2015, 03:04 AM
Guloluseus Guloluseus is offline Rounding to nearest 0.25 Windows 7 64bit Rounding to nearest 0.25 Office 2010 32bit
Competent Performer
Rounding to nearest 0.25
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default Rounding to nearest 0.25

I have a table of task durations which have been calculated from actual dimensions (length, area etc) which are then divided by the expected outputs to get a total duration.



This gives me a column of numbers representing task durations in days. To use this, I need to round up each duration to the nearest quarter day to avoid problems.

In this case if I had 2.1, 2.224, 2.06, all would need to be rounded to 2.25, and 2.55, 2.7, 2.6 would need to be rounded up to 2.75. Tasks are all below 20 days, so range is 0-20.

Thanks in advance
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word not 'rounding' letters up to word in next line (parents and orphans) Asa Word 4 09-13-2014 06:47 PM
Rounding values inconsistent required_username Excel 10 06-05-2014 05:35 AM
Custom formatting code - rounding problem venkys4u Excel 1 08-14-2012 07:45 PM
Rounding to nearest 0.25 Standard Dev. Rounding - Excel judicial85 Excel 1 08-28-2011 05:41 PM
Rounding to nearest 0.25 Federal financial rounding? markg2 Excel 6 05-26-2010 09:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft