group by

Hello ,          I would like to group my table like that  :    8:00:00 -> 17  8:01:00 ->42  8:02:00 -> 29(27+2) 8:03:00 -> 36 (21+5+10) 8:04:00 -> 9 ( 7 + 2)     I tested different w...