Hello,
I have a column of mixed numbers that represents how long it takes my company to do a task. I'm trying to come up with a formula that looks at the decimal of the mixed number and converts it to the nearest .25 interval so that I know how much time to charge for doing that task. Is there any formulas that look at decimal places?
Examples of what I'm trying to do:
3.15 > 3.25
5.6 > 5.5
3.5 > 3.5
18.2 > 18.25
1.4 > 1.5
3.5 > 3.5
1.4 >1.5
2.8 > 2.75
Bookmarks