An employee works 6 days a week and does a total of 55 hours. This includes 9 hours on Sunday. I need to show the Sunday and overtime separately. A normal day excl lunch break is 7.5. Please advise how you would show Normal time, overtime and Sunday time.
In a second example- the employee works 4 days in the week. 2 days of 12 hours and 2 days of normal hours of 7.5, one of which is a Sunday, therefore 40 hours in total. How would you calculate overtime, Sunday time and Normal time.