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
Dipwind


--
Dipwind
------------------------------------------------------------------------
Dipwind's Profile: http://www.excelforum.com/member.php...o&userid=36276
View this thread: http://www.excelforum.com/showthread...hreadid=561712