Can someone help me develop a formula? If an employee's weekly work hours are more than 35, in one column list the number of works worked between 35 and 40, and in another column for any hours worked over 40 in a week, list the number of hours that exceed 40.
If it's less than 35, return 0
If it's between 35  40, return the difference between 40 and 35 (positive numbers)
If over 40, return hours worked over 40
If it's less than 35, return 0
If it's between 35  40, return the difference between 40 and 35 (positive numbers)
If over 40, return hours worked over 40
Attachments

8.8 KB Views: 6