Calculate average of non zero values within an hour

[Prevost]

Hi There,

I have a date & time column that increments by 1 minute in each row. The format is dd/mm/yyyy hh:mm. I have a corresponding power value for each minute interval time in another column. What I would like to do is obtain the hourly average of power for all non zero entries.
The code would have to check to see if the date & time column was within a certain hour, then average all the values...but I am not sure how to approach that in VBA world.

Thanks!