Thank you for your reply and I appreciate the effort into looking into this. I dont understand how that last code is working as I dont see where it is calculating overtime hours. This spreadsheet that I am making needs to tell me how much my paycheck will be, after taxes. The part of the formula that we are working on is just for the Gross Pay then it goes on and calculates the taxes and deductions. So I would need to have it work and calculate automatically overtime hours as well as regular hours. For instance if I work 35 in D5 and get paid 8.00 an hour in D then cell D8 returns Gross Pay of 280.00. If I work 43 hours in D5 at the same hourly rate then D8 returns 356.00 for Gross Pay.

This is the other code I have written and cant get to work just right. the way it is now it works fine if I work overtime but if I do not it just writes false in cell D8 instead of calculating those hours.

Thanks for any help you can and have given.

clo312