I have some data from a parking survey. The data shows the time slots in which each vehicle was present, with an individual code for each vehicle. I'd like to create a matrix with the arrival time slots on one axis, the departure time slots in another axis and the number of vehicles arriving and departing in each slot.

An extract from the raw survey data is below. Looking at row 60 for example, vehicle SE65 arrived at 0700 and departed at 0830, so I would like a '1' in my matrix at the intersection of 0700 and 0830. Similarly, vehicles SB13 and SA69 arrived at 0830 and departed at 0830 so I would like a '2' in my matrix at the intersection of 0830 and 0830; vehicles ROC62 and SP07 both arrived at 0830 and departed at 0900, so I'd like a '2' in the matrix at the intersection of 0830 and 0900.
Capture.PNG

The logical test to get the arrival time is if the text appears in a cell but not in the adjoining cell to the left and for the departure time is if the text appears in a cell but not the adjoining cell to the right. I have been trying various SUMPRODUCT functions but can't get anything to work correctly. Any ideas on how to solve this?