Whoa Shiromagius,
This rocks! It is rather early in the AM here and I need to get some sleep. But I did do a few tests with the code you provided. It so far works. I had to tweak it a little since, lets say the number was 96. Since their is no decimal, I want it take the number as is and add it to the original number which would make it 99 (since 96/32 = 3).
So the code looks like this now (bolding what I changed):
=IF(A1/32-INT(A1/32) = 0.5, A1+A1/32,IF(MOD(A1,32)=0.1,A1+A1/32+0.5,CEILING(A1/32,0.5)+A1))
I will play with it some more later when I wake up. I'll be sure to contact you if I need further assistance!
Thanks again!
-SlickVic78