Hi Everyone
I have a data table that shows a list of times Trailers were tipped, from which site in time order such as
<tbody>
</tbody>
I then on a separate sheet have a list of data with times on which I need to return the value of the Despatch Site for that time.
So
<tbody>
</tbody>
Would return These despatch sites as they fall within the time period before the next Trailer
06:20 MD01
06:31 MD01
07:50 MD19
Does anyone know of a calculation for me to do this and not do it manually?
Thanks in advance
I have a data table that shows a list of times Trailers were tipped, from which site in time order such as
Date | Despatch Site | Time of Trailer Unloaded | |
28/02/2016 | MD01 | 06:13 | |
28/02/2016 | KA09 | 06:56 | |
28/02/2016 | MD19 | 07:42 |
<tbody>
</tbody>
I then on a separate sheet have a list of data with times on which I need to return the value of the Despatch Site for that time.
So
06:20 |
06:31 |
07:50 |
<tbody>
</tbody>
Would return These despatch sites as they fall within the time period before the next Trailer
06:20 MD01
06:31 MD01
07:50 MD19
Does anyone know of a calculation for me to do this and not do it manually?
Thanks in advance