I work with a workbook where I register the time used by each worker.

I intend to obtain the totality of hours for each employee a day. the number of employees can vary a day, but they are usually 30.

Rate for employee varies and I have that information in another table that is constituted like this: base + skill + indirect + tax + overtime.

All the employees have an only badge what allows me to know that the employee 27 receives x skill or x base.

my problem is to collect information on overtime, because the rate overtime is only valid after they do 40 hours.

If the employee 27 on Friday has already done 40 hours, the hours that he does beyond will have the rate overtime. now I make that manually, there is some formula for I get that information in an automatic way?

can anybody help?

many thanks

Joćo Pedro