Is this possible, I have a start and end time in two cells and what I would like to be able to do is lookup this start and end time and return the time. I have attached an example of what I mean, so in the first example my start time is 7:00 and end time is 12:30 and on the chart I have three times, first is from 6:00-6:30, second is from 12:00-12:30 and third is from 14:00-14:30, therefore the result or answer for example 1 should be :30. For example 2, the sart time is 6:00 and end time is 12:30, thus the answer should be 1:00. Is there a formula that can do this? Thanks!
Bookmarks