Calculate time of arrival with IF condition based on departure

Hello everyone,

I need bit of help with the sheet attached.

I have to calculate the time of arrival from a to b with the condition that there might be 2 different departure places.

For example, i have column C (Departure) and column D (arrival). Now, in sheet TimpDistanta i set up the time that takes to transit from C to D.

Now, this is a transport plan, and in some cases, one truck might load from Campus Calan, go to one city and after that to the next, so in column C will appear 2 departure places.

So, the result should be like this:

Row 2 and 3, same truck, 2 deliveries, calculate in column Y the time on the clock (you can shitch to AM/PM if you like) of arrival to every store.
Row 3, different truck, 1 delivery, calculate in column Y time o arrival.

And so on.....

A bit of help with translation, Column P is departure time, column X is time it takes (number of hrs) from C to B

Thank you!

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

The new title is still generic. Please add more detail to it. Thanks.

Thank you - your title is now acceptable.

There are no expected results in column H.

Nr of hr from C to D

Should this be from B to C?

Try this:

=IFERROR(IF(B2<>"CAMPUS CALAN",F3+G3+$L$3+G2,F2+G2),F2+G2)

For your locale:

=IFERROR(IF(B2<>"CAMPUS CALAN";F3+G3+$L$3+G2;F2+G2);F2+G2)

Glad to have helped.

Departure hr F2=IF(B2="CAMPUS CALAN",E2+$L$6,FILTER($H$2:$H$14,($A$2:$A$14=A2)*($B$2:$B$14="CAMPUS CALAN")*($D$2:$D$14=D2))+$L$3)
Estimated hr of arrival to store H2=F2+G2
with Unloading time at 1st store at L3=2:00 and Loading time at L6=1:00