There is a registration table, which records the entering and leaving time of customers in a certain bathroom on a certain day, and part of the data is as follows:

The task is to count the situation of customers in each one-hour time period from 18:00 to 22:00. If the customer is in the bathroom during a time period, fill in 1, otherwise leave it blank, as shown in the following figure:

Enter in cell F2:

A2: Create a table sequence using 4 groups of Male and Female as its columns
A3: Convert the start time 18:00 to the value as which Excel store
A4: Loop through each row of A1, and append a new row in A2; loop through 4 time periods, and calculate the start time t1 and end time t2 of each time period; calculate the column number k to be filled in according to the gender of the customer. If the customer is still in the bathroom during a period, then fill in 1 in the kth column of the current row of A2

esProc Desktop and Excel Processing
14.9 Expand into multiple columns horizontally
14.11 Generate permutations and combinations