On Thursday, July 17, 2014 5:11:22 AM UTC-7, Claus Busch wrote:
Hi Howard,



Am Thu, 17 Jul 2014 05:02:03 -0700 (PDT) schrieb L. Howard:



Mighty fine! That works very well!



and here is a formula that works:

=SUMPRODUCT(($G$2:$G$100+$H$2:$H$100-$E$2:$E$100-$F$2:$F$100)*($H$2:$H$100<"")*($D$2:$D$100=M2))





Regards

Claus B.

Thanks, Claus.

I like the formula better in this case and it is working perfect.

Howard

Hi Howard,

Am Thu, 17 Jul 2014 09:59:04 -0700 (PDT) schrieb L. Howard:

I like the formula better in this case and it is working perfect.

if you want to roundup to the next 10th minute try:
=IF(MINUTE(SUMPRODUCT(($G$2:$G$100+$H$2:$H$100-$E$2:$E$100-$F$2:$F$100)*($H$2:$H$100<"")*($D$2:$D$100=M2)))= 0,SUMPRODUCT(($G$2:$G$100+$H$2:$H$100-$E$2:$E$100-$F$2:$F$100)*($H$2:$H$100<"")*($D$2:$D$100=M2)),R OUNDUP(SUMPRODUCT(($G$2:$G$100+$H$2:$H$100-$E$2:$E$100-$F$2:$F$100)*($H$2:$H$100<"")*($D$2:$D$100=M2))*1 44,0)/144)
or look again in OneDrive


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

if you want to roundup to the next 10th minute try:

=IF(MINUTE(SUMPRODUCT(($G$2:$G$100+$H$2:$H$100-$E$2:$E$100-$F$2:$F$100)*($H$2:$H$100<"")*($D$2:$D$100=M2)))= 0,SUMPRODUCT(($G$2:$G$100+$H$2:$H$100-$E$2:$E$100-$F$2:$F$100)*($H$2:$H$100<"")*($D$2:$D$100=M2)),R OUNDUP(SUMPRODUCT(($G$2:$G$100+$H$2:$H$100-$E$2:$E$100-$F$2:$F$100)*($H$2:$H$100<"")*($D$2:$D$100=M2))*1 44,0)/144)

or look again in OneDrive





Regards

Claus B.

What could be better than all those choices! Thanks a million Claus.

Howard