KK1966

01-21-2010, 11:45 PM

Can anyone help me why does can’t round with sumproduct formulas as the value in col G is 00:00:00.

What’s I want to get if the return value = 12:14:54

Can range A1 be come = 12:15 as range A1 format 00:00, but it is resulted 12:14

I try formulas below but it not work

=SUMPRODUCT(ROUND(G3:G500(($A$3:$A$500="Fcode")*($B$3:$B$500="Ftc")*(MOD($F$3:$F$500,1)<"15:00:00"+0),$G$3:G$500),3))

Thanks

What’s I want to get if the return value = 12:14:54

Can range A1 be come = 12:15 as range A1 format 00:00, but it is resulted 12:14

I try formulas below but it not work

=SUMPRODUCT(ROUND(G3:G500(($A$3:$A$500="Fcode")*($B$3:$B$500="Ftc")*(MOD($F$3:$F$500,1)<"15:00:00"+0),$G$3:G$500),3))

Thanks