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

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

Hi Roy, what data is in Beezidtable[final] and beezidtable[time]? Is your PC's clock correct?



rwtrader wrote:

Troubleshoot
04-Jun-10

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

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Binding Beyond the Limitation of Name Scopes
http://www.eggheadcafe.com/tutorials...nd-the-li.aspx