Traveling Time to different destinations problem, please help!

Dear community,

I turn to you to ask for your help. I have a problem that I need to tackle before Monday! I have a huge amount of data in the same format as the little file attached.

Basically the representative data that I copied and pasted needs to be analyzed to solve three questions:

- Given the initial time of departure and the time of arrival of a particular car to a particular destination:
1) What is the time the first car to the first destination departs
2) What is the time the last car to the first destination arrives
3) What is the time traveled by each car (time of arrival minus time of departure = basically the cycle)

I thank you very much for any help someone can give me on this matter.

Best regards,



ORLANDO

In F6, copied down:

=IF(D6>E6,TEXT((24-D6)+E6,"hh-mm"),TEXT(E6-D6,"hh-mm"))

Assuming your version of Excel is up-to-date, in F14:

=MINIFS($D$6:$D$12,$B$6:$B$12,"A",$C$6:$C$12,MINIFS($C$6:$C$12,$B$6:$B$12,"A"))

and in F15:

=MAXIFS($E$6:$E$12,$B$6:$B$12,"A",$C$6:$C$12,MAXIFS($C$6:$C$12,$B$6:$B$12,"A"))