基于一定条件的Excel列数据发生频率

I have a column (Table 1 below) with time data in 24 hour format saved as text.I want Table 2 to be populated by the hour and adding all the occurrences for the hour.I have a column (Table 1 below) with time data