View Single Post
 
Old 10-27-2015, 03:04 AM
Guloluseus Guloluseus is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
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