Hey guys I have the following excel
20130325213807.png

Now I would like to enter the correct text value for column A exactly as in the example.
As I said sch1 - lasts from date 01.03.2013 at 7:00 to 01.03.2013 at 14:59, sch2 - lasts from date 01.03.2013 at 15:00 to 01.03.2013 at 22:59 and sch3 - lasts from date 01.03.2013 at 23:00 to 02.03.2013 at 06:59 but I am not sure about how to make it loop by the date since as you can see at sch3 it needs to be part of next day (from date 01.03.2013 at 23:00 to 02.03.2013 at 06:59). I can do it if I have only two days, but not sure how to change the formula when I have more dates (ex. from 01.03.2013 to 04.03.2013)
I have also included the test excel file if someone wants to give it a try.

Thank you for the support.

test.xlsx