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

But 8*16 = 128 and 8*17 = 136
best wishes
Bernard

"Confused" wrote in message
...
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

Yes, you are indeed confused, Becky.
128 and 136 are both multiples of 8, so 136 is the correct answer.
128+8=136. Why would you expect the answer to be 128?

Just as =floor(8,8) gives 8, and =floor(128,8) gives 128, =floor(136,8)
gives 136.
Any time that the first argument (number) of the FLOOR function is an exact
multiple of the second argument (significance), the output is exactly that
first argument (number).
--
David Biddulph

"Confused" wrote in message
...
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

Check out help on FLOOR....Rounds number down, toward zero, to the nearest
multiple of significance.

'For .5 hours for every 8 hours worked..would be....
=INT(136/8)*0.5



=floor(136,8) should return 136 only..
or try with 136 in cell A1
=floor(A1-1,8)

If this post helps click Yes
---------------
Jacob Skaria


"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

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

One thought:

=floor(B5,8) might not return what you think, if B5 contains 135.999999 but
displays 136

Eric

"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