Hello there. I am trying to forecast full-time employees and I need round the cells with the FTE (full time employees) numbers in them. I only want to round up if the decimal value is greater than .25 , for example:
200 Hours of work needed that will work out to 1.25 FTE needed, when dividing by a standard 160 hour 4 week cycle. I would like that to stay expressed as 1.25 however any value greater than that I would want rounded up to the nearest whole number. The same would apply if the hours were 385 which would result in 2.4 FTEs needed which I would want rounded to 3.
Any advice will be most appreciated.
Thanks a metric tonne.
Ben
