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