Sum work hours to hours & nearest 10th of an hour
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
|