Try
=AVERAGEIF(Range, "" & NOW()-INT(NOW()) , Sum Range)

"rwtrader" wrote:

Can someone help me with the following statement:
=AVERAGEIFS(BeezidTable[final],BeezidTable[time],"TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()) )")
It returns DIV/0, but it should return a proper average.
Thanks, Roy