Column A contains formula in original post to calculate turn-around time
Column B has driver's load arrival time,
Column C has the driver name.

Departure time is NOT tracked. Turn-around time is time difference between
the arrival time of the most recent load and the arrival time of the load
that same driver brought in from the same farm last time he brought a load in.



"JulieD" wrote:

Hi

how is the worksheet set up (ie what column has driver name / number) what
column has depart & arrive times?

Cheers
JulieD

"rcmodelr" wrote in message
...
I am trying to set up a spreadsheet where I can track driver arrival times
to
figure the individual driver round-trip turn-around time.

Normally, there will be 3 or 4 drivers arriving before same driver arrives
again.
Some cases, however, driver will arrive again with only 1 driver since
last
arrival.

=B19-INDIRECT(ADDRESS(ROW(C19)-6+MATCH(C19,C14:C18,0),2)) Works with 4 or
5
drivers hauling from same farm.

I need a formula that will work if only 2 drivers are coming from the
farm,
but same formula needs to find correct arrival time if 4 or 5 drivers are
coming from same farm.