=IF(ISERROR((SUMPRODUCT(--(wekday=CHOOSE(WEEKDAY(B2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")),--(HOUR(wekdate)=CHOOSE(aHours,"23",22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0)),--(Hdcnt)))/SUMPRODUCT((HOUR(wekdate)=CHOOSE(aHours,"23",22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0)*(wekday=CHOOSE(WEEKDAY(B2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"))))),"",(SUMPRODUCT(--(wekday=CHOOSE(WEEKDAY(B2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")),--(HOUR(wekdate)=23),--(Hdcnt)))/SUMPRODUCT((HOUR(wekdate)=CHOOSE(aHours,"23",22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0)*(wekday=CHOOSE(WEEKDAY(B2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")))))
Bookmarks