SOLVED

Need assist with formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3345884%22%20slang%3D%22en-US%22%3ENeed%20assist%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3345884%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20of%20registrations%20and%20want%20to%20count%20the%20number%20in%20each%20category%20(T%2C%20S)%20that%20occurs%20at%20every%20whole%20hour.%26nbsp%3BIf%20no%20registration%20at%20a%20certain%20time%2C%20it%20should%20fill%20inn%20%220%22.%26nbsp%3B(Dataset%20is%20below)%3CBR%20%2F%3EWant%20it%20to%20look%20like%20this%20(example)%3A%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22265%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2273%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ECategory%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDate%26nbsp%3B%3C%2FTD%3E%3CTD%3ETime%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E00%3A00%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E01%3A00%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E02%3A00%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E03%3A00%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E04%3A00%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E05%3A00%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3EDataset%3A%3C%2FU%3E%3C%2FP%3E%3CTABLE%20width%3D%22221%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2273%22%3EDate%3C%2FTD%3E%3CTD%20width%3D%2284%22%3EHour%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ECategory%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E00.38%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E01.04%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E02.01%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E02.33%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E03.11%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E04.05%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E04.06%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E04.23%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E05.28%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E05.28%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E06.09%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E06.33%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E07.03%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E07.09%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E07.51%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E07.56%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E08.17%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E08.18%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E08.29%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E08.44%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E09.05%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E09.05%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E09.23%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E10.34%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E10.38%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E11.22%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E11.40%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E11.54%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E12.16%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E12.30%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E13.17%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E14.42%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E15.59%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E16.42%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E20.01%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E20.55%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E21.07%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E21.13%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E21.39%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E22.18%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E22.22%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E22.22%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E22.29%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E22.50%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E22.53%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-04%3C%2FTD%3E%3CTD%3E23.41%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E00.33%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E01.37%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E02.29%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E03.07%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E04.07%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E04.07%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E04.33%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E04.48%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E05.05%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E05.56%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E06.19%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E06.58%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E07.12%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E07.52%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E06.54%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E08.32%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E08.41%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E09.03%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E09.16%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E09.18%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E09.34%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E09.57%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E10.21%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E10.31%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E10.43%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E10.58%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E11.10%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E12.26%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E12.42%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E14.19%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E15.01%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E15.04%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E15.40%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E15.46%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E15.48%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E15.42%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E16.04%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E16.27%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E16.48%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E17.27%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E17.29%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E17.48%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E18.20%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E18.27%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E18.36%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E18.46%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E19.01%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E19.31%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E19.38%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E20.01%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E20.02%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E20.51%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E21.28%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E21.45%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E21.50%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E22.08%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E22.12%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E22.17%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E22.20%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E22.28%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E22.44%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E22.54%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-05%3C%2FTD%3E%3CTD%3E23.52%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E01.01%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E01.07%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E03.19%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E03.20%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E04.10%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E04.13%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E05.14%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E05.23%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E05.46%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E05.53%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E06.04%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E06.42%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E06.56%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E07.08%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E07.29%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E07.29%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E07.37%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E07.37%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E07.37%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E07.41%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E07.41%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E07.49%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E07.51%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E07.57%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E08.00%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E08.00%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E08.06%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E08.06%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E08.08%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E08.11%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E08.38%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E09.08%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E09.11%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E10.04%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E10.05%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E10.06%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E10.20%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E10.26%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E10.39%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E10.40%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E10.42%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E10.45%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E11.05%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E11.18%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E11.18%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E11.28%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E11.41%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E11.45%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E12.26%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E12.29%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E12.34%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E12.44%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E12.49%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E12.55%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E13.33%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E15.20%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E16.16%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E16.21%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E16.23%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E16.30%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E16.52%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E17.03%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E17.04%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E17.28%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E17.29%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E17.38%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E17.38%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E18.00%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E18.14%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E18.15%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E18.23%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E18.58%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E18.59%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E19.10%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E19.23%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E19.39%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E19.50%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E20.14%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E20.27%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E22.00%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-06%3C%2FTD%3E%3CTD%3E23.52%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E01.01%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E01.07%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E03.19%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E03.20%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E04.10%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E04.13%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E05.04%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E05.14%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E05.46%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E05.53%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E06.04%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E06.42%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E06.56%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E07.08%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E07.29%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E07.29%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E07.37%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E07.37%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E07.37%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E07.40%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E07.43%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E07.44%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E08.00%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E08.10%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E08.16%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E08.19%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E08.36%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E08.48%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E09.10%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E09.18%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E09.28%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E09.34%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E09.46%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E10.03%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E10.19%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E10.24%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E10.53%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E11.39%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E11.43%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E13.43%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E14.07%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E14.54%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E15.07%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E17.56%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E18.01%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E18.15%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E19.19%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E19.45%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E19.49%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E19.49%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E20.07%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E20.41%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-07%3C%2FTD%3E%3CTD%3E21.45%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-08%3C%2FTD%3E%3CTD%3E06.00%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-08%3C%2FTD%3E%3CTD%3E08.14%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-08%3C%2FTD%3E%3CTD%3E08.27%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-08%3C%2FTD%3E%3CTD%3E08.49%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-08%3C%2FTD%3E%3CTD%3E09.01%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-08%3C%2FTD%3E%3CTD%3E09.10%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-08%3C%2FTD%3E%3CTD%3E09.21%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-08%3C%2FTD%3E%3CTD%3E09.51%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-08%3C%2FTD%3E%3CTD%3E09.52%3C%2FTD%3E%3CTD%3ES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2021-07-08%3C%2FTD%3E%3CTD%3E09.52%3C%2FTD%3E%3CTD%3ET%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3345884%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3345953%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20assist%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3345953%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1369923%22%20target%3D%22_blank%22%3E%40LBendix%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20option%20is%20a%20pivottable%20-%20see%20the%20attached%20sample%20workbook.%3C%2FP%3E%0A%3CP%3EI%20added%20an%20auxiliary%20column%20%22Hour%20(rounded)%22%20to%20the%20source%20data%2C%20and%20used%20that%20instead%20of%20the%20Hour%20column%20in%20the%20pivot%20table.%3C%2FP%3E%0A%3CP%3EI%20changed%20the%20pivot%20table%20to%20tabular%20format%2C%20specified%20that%20it%20should%20have%20no%20subtotals%20and%20grand%20totals%2C%20and%20that%20labels%20should%20be%20repeated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3346023%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20assist%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3346023%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1369923%22%20target%3D%22_blank%22%3E%40LBendix%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20add%20a%20working%20column%20'Round%20hour'%20next%20to%20your%20data%3C%2FP%3E%3CP%3EThen%20using%20HOUR%20function%20you%20can%20get%20the%20round%20(whole%20hours).%3C%2FP%3E%3CP%3EThen%20you%20can%20summarize%20the%20results%20with%20COUNTIF%20or%20pivot%20table%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3346307%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20assist%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3346307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F15497%22%20target%3D%22_blank%22%3E%40Kolyu%20Minevski%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20used%20the%20HOUR%20and%20COUNTIF%20to%20get%20half%20way%2C%20but%20still%20need%20input%20on%20the%20code%20to%20summarize%2F%20sum%20up%20the%20numbers%20each%20hour%2F%20date.%20Please%20see%20the%20attached%20dataset%3CBR%20%2F%3EAny%20input%20is%20appreciated.%20Thanks%20again!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3346311%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20assist%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3346311%22%20slang%3D%22en-US%22%3ENot%20very%20familiar%20with%20pivot%20unfortunately%2C%20but%20thanks%20anyway!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3346398%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20assist%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3346398%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1369923%22%20target%3D%22_blank%22%3E%40LBendix%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%20It%20uses%20SUMPRODUCT%2C%20not%20COUNTIF.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3346816%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20assist%20with%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3346816%22%20slang%3D%22en-US%22%3EThank%20you%2C%20this%20solved%20it!%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a list of registrations and want to count the number in each category (T, S) that occurs at every whole hour. If no registration at a certain time, it should fill inn "0". (Dataset is below)
Want it to look like this (example):  

  Category 
Date TimeTS
2021-07-0400:001 
2021-07-0401:001 
2021-07-0402:0011
2021-07-0403:001 
2021-07-0404:003 
2021-07-0405:002 
    

 

 

Dataset:

DateHourCategory
   
2021-07-0400.38T
2021-07-0401.04T
2021-07-0402.01S
2021-07-0402.33T
2021-07-0403.11T
2021-07-0404.05T
2021-07-0404.06T
2021-07-0404.23T
2021-07-0405.28T
2021-07-0405.28T
2021-07-0406.09T
2021-07-0406.33T
2021-07-0407.03T
2021-07-0407.09S
2021-07-0407.51T
2021-07-0407.56T
2021-07-0408.17T
2021-07-0408.18T
2021-07-0408.29T
2021-07-0408.44T
2021-07-0409.05T
2021-07-0409.05T
2021-07-0409.23T
2021-07-0410.34T
2021-07-0410.38T
2021-07-0411.22S
2021-07-0411.40T
2021-07-0411.54T
2021-07-0412.16T
2021-07-0412.30S
2021-07-0413.17T
2021-07-0414.42S
2021-07-0415.59T
2021-07-0416.42S
2021-07-0420.01T
2021-07-0420.55T
2021-07-0421.07T
2021-07-0421.13T
2021-07-0421.39T
2021-07-0422.18T
2021-07-0422.22T
2021-07-0422.22T
2021-07-0422.29T
2021-07-0422.50T
2021-07-0422.53T
2021-07-0423.41T
2021-07-0500.33T
2021-07-0501.37T
2021-07-0502.29T
2021-07-0503.07S
2021-07-0504.07T
2021-07-0504.07T
2021-07-0504.33S
2021-07-0504.48S
2021-07-0505.05T
2021-07-0505.56T
2021-07-0506.19T
2021-07-0506.58S
2021-07-0507.12S
2021-07-0507.52S
2021-07-0506.54T
2021-07-0508.32S
2021-07-0508.41T
2021-07-0509.03T
2021-07-0509.16T
2021-07-0509.18T
2021-07-0509.34T
2021-07-0509.57T
2021-07-0510.21T
2021-07-0510.31S
2021-07-0510.43T
2021-07-0510.58T
2021-07-0511.10T
2021-07-0512.26S
2021-07-0512.42T
2021-07-0514.19S
2021-07-0515.01T
2021-07-0515.04S
2021-07-0515.40T
2021-07-0515.46T
2021-07-0515.48T
2021-07-0515.42T
2021-07-0516.04T
2021-07-0516.27S
2021-07-0516.48T
2021-07-0517.27T
2021-07-0517.29T
2021-07-0517.48T
2021-07-0518.20T
2021-07-0518.27T
2021-07-0518.36T
2021-07-0518.46T
2021-07-0519.01T
2021-07-0519.31S
2021-07-0519.38T
2021-07-0520.01T
2021-07-0520.02S
2021-07-0520.51S
2021-07-0521.28S
2021-07-0521.45S
2021-07-0521.50T
2021-07-0522.08S
2021-07-0522.12S
2021-07-0522.17T
2021-07-0522.20T
2021-07-0522.28S
2021-07-0522.44T
2021-07-0522.54T
2021-07-0523.52T
2021-07-0601.01S
2021-07-0601.07S
2021-07-0603.19T
2021-07-0603.20S
2021-07-0604.10S
2021-07-0604.13T
2021-07-0605.14T
2021-07-0605.23T
2021-07-0605.46S
2021-07-0605.53S
2021-07-0606.04T
2021-07-0606.42T
2021-07-0606.56T
2021-07-0607.08T
2021-07-0607.29T
2021-07-0607.29T
2021-07-0607.37T
2021-07-0607.37T
2021-07-0607.37T
2021-07-0607.41T
2021-07-0607.41T
2021-07-0607.49T
2021-07-0607.51T
2021-07-0607.57T
2021-07-0608.00T
2021-07-0608.00T
2021-07-0608.06S
2021-07-0608.06T
2021-07-0608.08T
2021-07-0608.11T
2021-07-0608.38T
2021-07-0609.08T
2021-07-0609.11T
2021-07-0610.04T
2021-07-0610.05T
2021-07-0610.06T
2021-07-0610.20T
2021-07-0610.26T
2021-07-0610.39T
2021-07-0610.40T
2021-07-0610.42S
2021-07-0610.45T
2021-07-0611.05T
2021-07-0611.18T
2021-07-0611.18T
2021-07-0611.28T
2021-07-0611.41T
2021-07-0611.45S
2021-07-0612.26T
2021-07-0612.29T
2021-07-0612.34S
2021-07-0612.44T
2021-07-0612.49T
2021-07-0612.55T
2021-07-0613.33T
2021-07-0615.20T
2021-07-0616.16T
2021-07-0616.21S
2021-07-0616.23T
2021-07-0616.30T
2021-07-0616.52S
2021-07-0617.03T
2021-07-0617.04T
2021-07-0617.28T
2021-07-0617.29T
2021-07-0617.38T
2021-07-0617.38T
2021-07-0618.00T
2021-07-0618.14T
2021-07-0618.15T
2021-07-0618.23S
2021-07-0618.58T
2021-07-0618.59T
2021-07-0619.10T
2021-07-0619.23T
2021-07-0619.39T
2021-07-0619.50T
2021-07-0620.14T
2021-07-0620.27T
2021-07-0622.00T
2021-07-0623.52T
2021-07-0701.01S
2021-07-0701.07S
2021-07-0703.19T
2021-07-0703.20S
2021-07-0704.10S
2021-07-0704.13T
2021-07-0705.04S
2021-07-0705.14T
2021-07-0705.46S
2021-07-0705.53S
2021-07-0706.04T
2021-07-0706.42T
2021-07-0706.56T
2021-07-0707.08T
2021-07-0707.29T
2021-07-0707.29T
2021-07-0707.37T
2021-07-0707.37T
2021-07-0707.37T
2021-07-0707.40S
2021-07-0707.43S
2021-07-0707.44T
2021-07-0708.00T
2021-07-0708.10T
2021-07-0708.16S
2021-07-0708.19T
2021-07-0708.36S
2021-07-0708.48T
2021-07-0709.10T
2021-07-0709.18T
2021-07-0709.28T
2021-07-0709.34T
2021-07-0709.46T
2021-07-0710.03S
2021-07-0710.19S
2021-07-0710.24S
2021-07-0710.53T
2021-07-0711.39T
2021-07-0711.43T
2021-07-0713.43T
2021-07-0714.07T
2021-07-0714.54T
2021-07-0715.07T
2021-07-0717.56T
2021-07-0718.01T
2021-07-0718.15S
2021-07-0719.19T
2021-07-0719.45T
2021-07-0719.49S
2021-07-0719.49T
2021-07-0720.07T
2021-07-0720.41T
2021-07-0721.45T
2021-07-0806.00T
2021-07-0808.14T
2021-07-0808.27T
2021-07-0808.49T
2021-07-0809.01T
2021-07-0809.10T
2021-07-0809.21T
2021-07-0809.51T
2021-07-0809.52S
2021-07-0809.52T

 

6 Replies

@LBendix 

One option is a pivottable - see the attached sample workbook.

I added an auxiliary column "Hour (rounded)" to the source data, and used that instead of the Hour column in the pivot table.

I changed the pivot table to tabular format, specified that it should have no subtotals and grand totals, and that labels should be repeated.

@LBendix 

You can add a working column 'Round hour' next to your data

Then using HOUR function you can get the round (whole hours).

Then you can summarize the results with COUNTIF or pivot table

@Kolyu Minevski 

I used the HOUR and COUNTIF to get half way, but still need input on the code to summarize/ sum up the numbers each hour/ date. Please see the attached dataset
Any input is appreciated. Thanks again!

Not very familiar with pivot unfortunately, but thanks anyway!
best response confirmed by LBendix (Occasional Contributor)
Solution

@LBendix 

See the attached version. It uses SUMPRODUCT, not COUNTIF.

Thank you, this solved it!