Calculate Overtime Weekday different from Weekend

Hi,
I’m trying to calculate the Overtime hours for anything that is over 8 hours for Monday thru Friday. For weekend days I want all hours worked for the day = Overtime.

I currently have this =IF(H5>=8,SUM(H5-8),0) but need to calculate hours worked according to days of the week.

Example -
Overtime =
If Sunday Total Hours = 10.50 then Overtime should display 10.50
If Monday Total Hours = 10.50 then Overtime should display 2.50

I've tried for several hours to find something already posted to the forum but haven't found anything that could help.

Your assistance will be greatly appreciated.

Attached spreadsheet to reflect layout and expected values.

since you've got that weekend column this will work:

Formula:

Please Login or Register  to view this content.

if you want to do it w/out the "Weekend Hours" column I can totally do that too... just let me know

Yes it does! I will be keeping the Weekend Column so your resolution is perfect. I tried to nest my IFs but failed horribly. Thank you for the fast response and helping me out!

glad to help