know the start time and end time of each sample, as shown in the following figure:
hu is the unique value of the sample. It is known that time1 and time2 are the start time and end time of the behavior, respectively. Now, we want to count the number of behaviors per minute, such as the number of sample behaviors per minute, such as 1815, 2200, 18, 22, 59, and so on. A total of 24,60,1440 minutes throughout the day.
for example, in line 8, 41000007 magnum timekeeping 15015 freestanding 15freel00000505140511459, then even if he acts at 15:50, he also acts at 15:51, and so on, until 15:59.
all times have been converted to HH:mm:00 and HH:mm: 59 points
now there are two immature ideas, you can refer to:
the first is to start the cycle from the first minute of the day to determine whether time1 < I < time2, then record + 1;
the second cycle of each sample to determine the number of minutes in which his behavior took place, and then recorded.
do you have a better solution?