Fill Column Based on Actual Time

[haiders7]

Hello Haider,
OK. I think I understand the logic now.
I think I needed this extra information. Either it was missing from, or I missed it / it was not clear enough , in your initial explanation.
I think I can do this for you.
But, If I use the current data file, then I will need a lot of time to check and debug and develop the code. As I mentioned already before… _ _……

So, If you want me to do this for you, then please supply me a reduced sample of data, so that I can develop the solution and include screenshots in the forum post. ( I could do this for you , but I do not have a lot of time. It is best that I spend the time doing what you cannot do).

Reduce the data in Sheet1 to about 3 sets of data, so approx (3x8) + Header = approx 25 lines
In Sheet2 include the data needed for sheet1, and possibly just a little bit more

You just need enough data to test out all scenarios. Choose your test data carefully so that all possible scenarios are included. Make the data realistic, but just include enough data to demonstrate all possible scenarios.

I have no more time today. I must go off line now until Wednesday. I will look here again on Wednesday.

If this is not quick enough for your urgency, and you find a solution elsewhere before Wednesday , then please let me know, so that I do not waste my time.

Thanks

Alan

Hi Alan

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.

Feel free to ask in case of any ambiguity and yes I can wait for next couple of days.

Many Thanks
Haider