counting numbers in different time intervals

[beldin2]

I need to count records in each 8h (starting from first adequate hour) during day (6-22) and in each 0,5h (starting from first adequate hour) during night (22-6). For example if there is 21:50; 22:20; 22:25; 22:30; 22:50; 23:05; 23:15; 23:45 then the first adequate hour for night is 22:20 and from it I would have to start counting. Consequently I would have to count how many records is between 22:20 and 22:50; 22:50 and 23:20; 23:20 and 23:50.There is attached example https://rg.to/file/a5973758f63cc9f6c837303cd7162b77/example.xlsx.html solved for two days in K column. Could you please help me?

 

[Gerald Higgins]

OK.

Why is the result given as 88 for 6:15 - 14:15 ?
I can only see about 30 values in that range.
ALSO, I notice that you seem to have quite a few merged cells - what's going on with them ?

 

[beldin2]

I will type other data in this sheet. I merged cells because I know that sometimes I will need a place for more than one record. I can unmerge those cells but numbers of records can not change so there will be empty records under those specific cells that were previously merged. Also there should be about 30 values in that range I don't know why it isn't.

 

[Gerald Higgins]

OK, I'm not seeing anything that looks like an answer to my question

Why is the result given as 88 for 6:15 - 14:15 ?