Rounding to nearest half

Hi Sophie

Great question! You are right in thinking ROUND won't do what you need. To round to half days you can use a different function called MROUND.

Here's an example to see how it works:

A B
Days To half days Formula
1.7 1.5 =MROUND(A2,0.5)
1.2 1.0 (copy down)
5.8 6.0
7.3 7.5
8.9 9.0

If you want to round to quarter days then use 0.25 rather than 0.5 as the multiple.

Does that work in your case or do you need 1.7 to change to 2.0 days rather than 1.5 days?

Regards
Doug

Doug Dunn
Best STL