Counting Only Specific Hours Between Two Times

What i need help with here is to find out how many hours (if any) are "Night hours" and/or "Weekend hours".
"Night" hours are from 21:00 to 06:00 any day.
"Weekend" hours are from Saturday 18:00 to Monday 06:00
It seems that the Total Hours part is working ok, i hope
But i just cant seem to find out how to get the Night and Weekend part to work
Iv looked high and low everywhere to try to find a salution to this, but just cant seem to find one
Iv attached a excel file incase that helps to understand what im looking for.