Hi,
I'm trying to work out if this is possible to do in one cell.

I have a spreadsheet with time based data. Column A has the time values in
15min intervals, Column B has the data for that 15min period.

What I want at the bottom of Column B, is a value representing the HOUR
where there is the highest number of values in Column B - ie the range of 4
cells within the column that has the highest value.

At the moment, this is calculated by Column C summing a 4-cell range in
Column B. At the bottom of Column C, the "max" function is being used to
return the highest value.

Is it possible to do this in the one cell?