I am banging my head against the wall with this....and I need help..... I will try to explain this correctly:
I have a bus timing sheet where I track the arrival time and departure time of buses at airport curbs. I get the calculated time by subtracting the latest departure time from the latest arrival time (arrival intervals are recorded:
EXAMPLE
ARRIVAL DEPARTURE TIMING
10:00:00 10:00:05
10:01:00 10:02:00 0:00:55
10:03:00 10:05:00 0:01:00
10:03:00 10:04:00 ########
10:06:00 10:08:00 0:02:00
The timing is derived for example by subtracting the latest arrival time from the last departure time examplecell E5-cell F4). The problem is, when two or more buses arrive at the same time the ##### occurs. I need the timing formula to search above, and if ###### exists, then for the above example, change the calculation to (cell E5-cell F3). In other words, find the latest departure time in the departure column to subtract. I hope this makes sense.
I have a bus timing sheet where I track the arrival time and departure time of buses at airport curbs. I get the calculated time by subtracting the latest departure time from the latest arrival time (arrival intervals are recorded:
EXAMPLE
ARRIVAL DEPARTURE TIMING
10:00:00 10:00:05
10:01:00 10:02:00 0:00:55
10:03:00 10:05:00 0:01:00
10:03:00 10:04:00 ########
10:06:00 10:08:00 0:02:00
The timing is derived for example by subtracting the latest arrival time from the last departure time examplecell E5-cell F4). The problem is, when two or more buses arrive at the same time the ##### occurs. I need the timing formula to search above, and if ###### exists, then for the above example, change the calculation to (cell E5-cell F3). In other words, find the latest departure time in the departure column to subtract. I hope this makes sense.