I am creating a spreadsheet in an early version of excel (02-03), for a
company who has several different employees. This company calculates
overtime on a daily basis, not weekly. I want Excel to automatically place
any hours beyond 8 into a separate column, so that those hours can be
calculated at overtime pay (time and a half). I am creating the master
sheet, so it has to be able to work even if there is no overtime for any
specific day. I can't just subtract 8 from every day, because then the
overtime column will go into the negative, and that cannot happen.
Therefore, I have to find a way for overtime hours to automatically be
filtered out into a separate column. I know all of the equations in order to
make the proper multiplication, but I just don't know how to filter out
overtime. Thanks so much!