FLOOR FUNCTION
the function is working correct, I think you need to check your math.
136 / 8 = 17
128 + 8 = 136
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Confused" wrote:
I am trying to use a floor function to calculate overtime. For every 8 hours
worked, our employees get paid .5 of OT. The floor function works up until
136 hours. Any ideas how to fix this. In other words, =floor(136,8), I
would expect it to be 128, but it is 136. HELP
Becky
|