Super Time sheet

[kolekbolek1283]

Hello,
i need help with my super time sheet.

i can't solved a logic how to split Normal working hours and extra working hours.
between 20:00 - 08:00 is external each day, and also for each holiday, wekeends.
also i have a problem after the holidays or saturday.... when someone working from 22:00 to 10:00 am, after 08:00 it should count as normal working hours not extra.
so total working hours 12 h minus brake 30 minutes is 11:30.
from 22:00- 08:00 count as extra working hours, after 8:00 count as normal working hours.
and only for saturday and holidays when they are from monday to friday (but friday without the night, because saturday and sunday couns as extra working hours :/



PLEASE HELP

i know, i'm stupid... but i cannot find the logic way how to do that....

 

[kolekbolek1283]

i wanna add full excel doc, i do not care about if someone take it and use it for personal use.
but i will add as jpg. you need to download it and change extension for .xlsm