Counting numbers above a certain value from within a table.

I have a hard time creating an excel table that I want to use in order to calculate the nightshift hours I spend doing my job
.
I want to create a formula that would automatically do this for me and I would just have to change the values.

As a side note: They are only considered night-shift hours if there are past 22:00 (10PM) and there are 3 consecutive hours. It should look something like this:
(I have attached a work-sheet)

What Should the formula be?

I tried multiple variants that involved =SUM, =AND, =COUNTIF

I have also tried using the formula:
=COUNTIF(A1:A10,">22:00")-COUNTIFS(A1:A10,">22:00",A2:A11,">22:00",A3:A12,">22:00")
But this is definitely not accurate,

Am I at least on the right path?

What result are you expecting in the sample workbook? You haven't told us.

All you have given us is this:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C
1	Day	Scheldue	Night-time hrs
2	1	15:00 - 23:30

Sheet: Sheet1

One row of data does not even match your attempted formula.

I think you need to provide a more detailed sample workbook, please.