Troubleshoot

  • Thread starter Thread starter rwtrader
  • Start date Start date
R

rwtrader

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/tutorial...f-49faac8854c8/wpf-binding-beyond-the-li.aspx
 
Back
Top