Create a excel which changes dynamically with two variables described below.

I have data with me as elaborated below. And I want to calculate no. of passengers in the system at a particular time slot.

So in the time frame of HH:MM-02:00 and HH:MM-00:40 all the passenger related to one flight will be there in the system. Same is the case for the remaining flights. Now what I want to calculate is, depend upon the flight departure time and no. of passengers, how many passengers will be there in the system at a particular time, let’s say at 03:00 and the calculations must change dynamically with the change in the departure time and no. of passenger.

Initially I thought that I will create 8 time slot for every flight depend upon HH:MM like if the flight time is 01:50 then time slots are 11:50, 12:00, 12:10, 12:20, 12:30, 12:40, 12:50, 01:00, 01:10 and assign the no. of passengers to that time slots like 26,26,26,26,38,38,38,38 and then I will group them using return multiple values through lookup and finally add the all passenger from all flights under one time slot of 10 minutes but I fail to do that because I am new to excel? Is there any other way to do this? Thank in advance for your support