Averaging Data Logger Output from Seconds to Minutes

in e2
=ROUND(SUMPRODUCT(--(FLOOR($A$2:$A$1000,1/1440)=D2)*$B$2:$B$1000)/60,0)
i used round because the actual averages are
19.71666667
39.71666667
82.46666667