On-peak, Mid-peak, and Off-peak calculations

[helloganesh]

Thanks to Alphafrog and km for helping yesterday with a variation of this problem.
Please help me in calculating the on-peak, mid-peak and off-peak hours of an equipment operation.
Attached is the spreadsheet that vividly describes my problem.
The problem is
1) Electricity on-peak, mid-peak and off-peak hours for any give day of the week is given
2) Equipment operating hour is known
3) I need to calculate the on-peak, mid-peak and off-peak equipment operating hours.
Thanks in advance for your help!

[daddylonglegs]

Are Saturday and Sunday operating hours correct? For Sat end time is before start time and for Sunday there is no end time. These formulas will work for other days (and corrected Sat)

In G19

=MAX(0,MIN(G7,G14)-MAX(G6,G13))

in G20

=MAX(0,MIN(G8,G14)-MAX(G7,G13))

in G21

=G14-G13-G19-G20

copy all three formulas across

[helloganesh]

Thank you.

[helloganesh]

Thank you.
If for Saturday all hours are off-peak, how can I modify this?
Thanks,
Ganesh