Thank you for your help in getting the formula right I do appreciate it, as to the other question calculating the overtime weekly while bieng paid bi weekly, that make sense and that is why i had responded i dont see how it could be done but I just thought of something....... I do not know how to do it but is there a way to create a formula across worksheets???? what i could do is create 2 work sheets one for each week then a third worksheet that totals the two worksheets together???? thus giving me the overtime weekly and still creating a two week calculator.
Thanks again
clo312