You lost me at

-starts 1:01AM - 7:59AM and display the total count in Sheet2, if there are no data in other specific time, then display a value "0"

For example for UK and M UK:

In Sheet 2, ("F5") = 3 as there are 3 data, G5=1, H5=0 and so on and so forth..
Sheet2 is blank. Is 1:01AM - 7:59AM supposed to be a time range? That's only 7 hours, so you'd need more than 3 cells for all time ranges.