Group by Time as varchar every 30 min

Question

I’ve column

Time > type varchar
hhmmss

I want to count every 30 minutes

010000 1
010100 2
013000 2
013200 3

Excepted output

01:00 5
01:30 3

Answer 1

maybe two grouping steps:
first hour, than minute.