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