Execl table is used for customer's specific visit time statistics to help users! !

According to the time period in column A, the 24-hour time period every day is divided into 12 time periods.

B3 = text (A3, "yyyy-mm-dd")

C3 = match ((hours (A3)+ minutes (A3)/60), {0,2,4,6,8, 10, 12, 14, 16,/kloc-.

Two formulas were copied down.

Green areas are filled as needed.

E3 = sum product (($ B3: $ b19 = $ D3) * ($ C3: $ c19 = e $2)) is copied to the yellow area.

Q3=SUM(E3:P3) Copy Down

E20=SUM(E3:E 19) is copied to the right.