I have a workbook set up with 7 worksheets. First one is Monday Daily Work Order, 2nd one is Tuesday...etc., 6th one is Weekly summary, and the 7th has all my data to choose from for other cells on the sheets.

In Monday A1 you choose a name from a list on sheet 7.

In Monday B1 I am entering a start time.

In Monday C1 I am entering an end time.

In Monday D1 I calculate total hours minus 1/2 hour for lunch.

Monday E1 is for overtime.

This is the same for each sheet Monday - Friday.

What I need to happen is..whenever a person hits 40 hours, it starts entering the overtime. They don't get overtime per day, only after 40 hours, whatever day that happens on. That should be easy enough (for some of you!! ).

Where I REALLY get stuck is....the same person might not be picked in the same place every day. For example: on Mondays sheet, Bob is selected in A1, Joe is selected in A2, Bill is selected in A3. But on Tuesday, Joe is selected in A1 and so on. How do I calculate time per person per day to reach 40 hours then calculate OT.

Wow!! Just read through this....I hope someone can understand what I need. Thanks in advance.....