![]() |
#1
|
|||
|
|||
![]()
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 ![]() |
|
![]() |
||||
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 |
![]() |
judicial85 | Excel | 1 | 08-28-2011 05:41 PM |
![]() |
markg2 | Excel | 6 | 05-26-2010 09:54 AM |