ploting time that is in excess of required working hours and recognizing non-working day/s

Hi everyone!

My problem is how can I plot the excess of 8 hours worked in a day of an employee. What I want to do is create a formula that will plot the excess 8 hours worked and recognized the non-working days (e.g. Saturday, Sunday and declared holidays). See attached sample file

Thank you in advance.