Hi all
stuck on how to get this to work
In cells A1 onwards i have this:
Time
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
In G 2 (after Time 3 end) i want to do a search and return the value of time related to the task, ie if it is 10:14 it will return the A1 result "Time 1 Start", but after the end point (10:15) it will not return anything until "Time 2 Start" so will only return the start time value and not end times? if that makes sense?
stuck on how to get this to work
In cells A1 onwards i have this:
Time
1 Start | Time 1 End | Time 2 Start | Time 2 End | Time 3 Start | Time 3 End |
10:00 | 10:15 | 12:30 | 13:00 | 15:00 | 15:15 |
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
In G 2 (after Time 3 end) i want to do a search and return the value of time related to the task, ie if it is 10:14 it will return the A1 result "Time 1 Start", but after the end point (10:15) it will not return anything until "Time 2 Start" so will only return the start time value and not end times? if that makes sense?