Opening and closing times past midnight

[Thoron6]

Morning,

I have posted this before but not been to clear as I'm not sure how to attach an example spreadsheet.

I have tried to simplify the problem.

Day	00:00	01:00	02:00	03:00	04:00	05:00	06:00	07:00	08:00	09:00	10:00	11:00	12:00	13:00	14:00	15:00	16:00	17:00	18:00	19:00	20:00	21:00	22:00	23:00
Sat	25	22	21	20	19	18	17	19	20	12	6	8	1	8	9	2	10	17	15	62	21	12	35	24
Sun	1	2	3	4	5	6	1	2	4	5	8	5	4	7	8	9	6	5	4	13	1	4	5	6
Mon	2	5	8	9	6	4	7	2	1	6	5	4	7	9	3	5	53	2	4	5	8	5	4	52
Tue	Etc
Wed
Thur
Fri

<tbody>
</tbody>

Sat	08:00	02:00
Sun	08:00	23:00
Mon	07:00	22:00
Tue	08:00	22:00
Wed	09:00	22:00
Thur	10:00	22:00
Fri	10:00	01:00

<tbody>
</tbody>

So I need to sum the totals outside of the opening hours. The main problem I am having is when the closing time is past midnight and not including the next days consumption in the relevant day calculations.

So the above example, I'd like to see

Sat = sum of numbers after 1am (due to Friday not closing until 1am) until it opens at 8am .. so 21 + 20+19+18+17+19...

As always, any help would be greatly appreciated.

Thank you

 

[Thoron6]

Also.... As this would be across a portfolio, the day and opening hours are not all the same. So Sunday 08:00 - 23:00 may only be for this specific example but may change at another branch.

Thank you