if else + loop + update values in a column vector

i have the following data.

X Hour Minute Second  Value
1 1    8     24     21 6898.4
2 2    8     24     22 6898.4
3 3    8     24     23 6898.4
4 4    8     24     24 6898.4
5 5    8     24     25 6898.4
6 6    8     24     26 6898.4

Now i want to record the average value of "Value" for observations when the value of the "Minute" variable stays same. For example, for the 24th minute, there are 30 observations, for the 25th minute, there could be 15 observations and so on.

I want to make a data frame which stores only the Hours, Minutes, and the average value of "Value" (over the seconds)