Time lookup

Sorry vba_php, your answer is not what I was asking, which maybe I wasn't clear about. The chart below with the three thirty minute intervals it what needs to be searched, not the difference in time of the two search examples. See if I can explain this differently, I want to be able to search for a time in the chart that is between the start/end time in the two examples, thus in the first example it should return 30 minutes and in the second it should return one hour.

i don't see any chart.

I highlighted it in yellow to make it clear.

Almost FlameRetired! It works for the two examples on the SS, but if I change the time to 6:00-13:00, by the chart I should get 1:00, but the formula returns :30.

Originally Posted by FlameRetired

If I understand correctly try this in cells C2:C3

Formula:

Please Login or Register  to view this content.

I had to make a slight change in the last < to > and now it appears to work! Although because the time is converted to a number I have problems with that even though you enter 14:30, it's not the same as another 14:30 because of conversion to a number in Excel. But, according to rules, that is another question to pose, but it appears for the most part I think this one can be considered solved!