L
lmeg
I have a spreadsheet showing:
Vehicle arrival times - 07:05. 09:01, 10:00 etc
Vehicle departure times = 08:06, 18:32 etc
Type of vehicle - 7.5t, 17t. 40t etc
I want to create a sum which calculates how many arrivals an
departures there are in a given time period according to vehicle type
e.g.
Between 07:00 - 07:59: 6, 7.5t lorries arrive and 12, 17t lorrie
arrive
Between 08:00 - 08:59: 2, 7.5t lorries arrive and 2, 17t lorrie
arrive
I've tried a sumproduct function but can't seem to get it quite right.
Is this the correct function to use or is there some other way
Vehicle arrival times - 07:05. 09:01, 10:00 etc
Vehicle departure times = 08:06, 18:32 etc
Type of vehicle - 7.5t, 17t. 40t etc
I want to create a sum which calculates how many arrivals an
departures there are in a given time period according to vehicle type
e.g.
Between 07:00 - 07:59: 6, 7.5t lorries arrive and 12, 17t lorrie
arrive
Between 08:00 - 08:59: 2, 7.5t lorries arrive and 2, 17t lorrie
arrive
I've tried a sumproduct function but can't seem to get it quite right.
Is this the correct function to use or is there some other way