Fill Column Based on Actual Time

[DocAElstein]

..
I have attached all the scenarios along with the data in the attached file. I highlight the scenarios in different colors so you can understand and check it with Sheet2 as well. Last scenario of D news has no data therefore in that scenario start time will be the New time....

Thanks, Haiden.
At first glance, that seems to make things a lot clearer.
( It seems that the there are now not just groups of 8 in Sheet1 ? )
The logic needed, generally, is quite complicated, that is to say a few things need to be done to get things into the right grouping. But it does not look difficult.
It just needs a bit of careful thought. I think I can do this.

I will post back later in the week, when I should have a solution for you

Alan