Fill Column Based on Actual Time

[DocAElstein]

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… _

.....please try to give a much more reduced size data sample.- Usually coding written to work on a small set of data will work with little or no modification on a larger sample… But it is a lot easier to develop and explain a solution at a forum with a much smaller sample. ....

_……

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


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.eileenslounge.com/viewtopic.php?f=44&t=40455&p=313035#p313035
https://www.eileenslounge.com/viewtopic.php?f=18&t=40411&p=312889#p312889
https://www.eileenslounge.com/viewtopic.php?f=18&t=40411&p=312886#p312886
https://www.eileenslounge.com/viewtopic.php?f=18&t=40411&p=312752#p312752
https://www.eileenslounge.com/viewtopic.php?f=18&t=40411&p=312734#p312734
https://www.eileenslounge.com/viewtopic.php?f=18&t=40411&p=312727#p312727
https://www.eileenslounge.com/viewtopic.php?f=18&t=40411&p=312724#p312724
https://www.eileenslounge.com/viewtopic.php?f=44&t=40374&p=312535#p312535
https://www.eileenslounge.com/viewtopic.php?p=312533#p312533
https://www.eileenslounge.com/viewtopic.php?f=44&t=40373&p=312499#p312499
https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg. 9xhyRrsUUOM9xpn-GDkL3o
https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg
https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=UgzlC5LBazG6SMDP4nl4AaABAg
https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=UgzlC5LBazG6SMDP4nl4AaABAg. 9zYoeePv8sZ9zYqog9KZ5B
https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg. 9xhyRrsUUOM9zYlZPKdOpm
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA