Thread: FLOOR FUNCTION
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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