merge timeslots to find the biggerone and output it

[66mamk]

Hello, i hit a snag.  Any help would be highly appreciated. Excel sheet is attached with two tabs, first with the input and second sheet with the output i am trying to get.  

Thanks again

[phottovy · Accepted solution]

This was trickier than I first thought and I'm sure there are much better solutions. Attached is one approach though.

[ArtApa · Accepted solution]

Hi @66mamk - It can be an idea for a weekly challenge! Here is my solution:

[66mamk]

Thank you so much!! it works

[66mamk]

@ArtApa Thank you sir!! it works