Autofill average values from consecutive 24 columns

Hi, I have a spreadsheet containing hourly data in a column (column G3 downwards in this case), so there are 24 daily values, after which the day changes and I have another 24 values and so on... Ho...