nedy_03
09-03-2007, 03:04 AM
Hello,
I'm facing this situation:
- in cell I5:AM5 I have a "weekday" function
- in cells I8:AM8 are put the number of hours worked by an employee
- in cell F8 are the number of hours that an employee should normaly work corresponding to the contract clause.
I would need a code that does the following : looks for values from I8:AM8 that are different from F8 value and for values that are "<>0" where weekday from I5:AM5 ">=6", and takes the hours from weekend (weekday>=6) and the hours from I8:AM8 grater than F8 value, and puts them in the cells that have the values less then F8.
The code should adjust the daily worked hours to the contractual hours, where it is possible.
Could anybody help me with that >?
Thx,
Nedy
I'm facing this situation:
- in cell I5:AM5 I have a "weekday" function
- in cells I8:AM8 are put the number of hours worked by an employee
- in cell F8 are the number of hours that an employee should normaly work corresponding to the contract clause.
I would need a code that does the following : looks for values from I8:AM8 that are different from F8 value and for values that are "<>0" where weekday from I5:AM5 ">=6", and takes the hours from weekend (weekday>=6) and the hours from I8:AM8 grater than F8 value, and puts them in the cells that have the values less then F8.
The code should adjust the daily worked hours to the contractual hours, where it is possible.
Could anybody help me with that >?
Thx,
Nedy