Selected Answer

Please find my solution in the attached workbook. There are lots of comments in the worksheet which I hope will prove helpful.

Key to the solution is the availability of true dates so that Excel can identify Sundays. My formulas presume that Sunday is day 1 of your week. I'm not sure if that changes with regional settings. Try it out. If 1 doesn't work for you, change the number (it might be 7) in the formulas or adjust your regional settings.

Column J has an array formula which must be confirmed with Control+Shift+Enter, pressed simultaneously, instead of the singular Enter you are accustomed to. The formula calculates the sum of a maximum of 8 hours for each day and then deducts the Sunday hours included in that total.

The formula in column K takes the total hours, minus the ST hours and subtracts the numbers of hours worked in excess of 4 on Sunday.

That leaves the double time hours to be the remaining balance. However, if you wish to calculate this total indpendently it would be the number of hours worked in excess of 4 on Sunday. You will find this formula in the remarks.

A second sheet was added to the originally attached workbook which enables equal treatment of a list of holidays and Sundays.

Good .luck!