Dears
i have a task to calculate the employees overtime per week. The normal duty of each employee is 7 hours per day starting from 9AM and 35hours per week.
If the employee works more than 40 hours per week, the overtime will be calculated for him. If he work less than 40 hours, he will get zero overtime.
The time is flexi. Between 9AM and 10AM. Any employee punch before 9AM is ok, but the counting of his 7 hours will start from 9AM and onwards only.
Can anybody help in creating such logic in Excel.
Thanks