Consolidate Hourly data

I've put a span in cell E2 (set to 3 hours) and set up appropriate formulae in columns F G and H in the attached workbook. You can change the value in E2 (eg to 1:00:00), and copy the formulae in F9:H9 further down until you reach 23:59:59.

Hope this helps.

Pete