UDF not working quite good

**lancer102rus** · 08-11-2014, 03:38 AM

I think you don`t need UDF. To sum only positive times use formula SUMIF. E.g.

=SUMIF(BQ5:BQ20,">0")

I have a question about your formula in column A. What is it calculating? Why do you work with time like with strings?

**Lukael** · 08-11-2014, 05:32 AM

Originally Posted by lancer102rus

I think you don`t need UDF. To sum only positive times use formula SUMIF. E.g.

=SUMIF(BQ5:BQ20,">0")

Unfortunatelly that is not working, and tried that before posting here. Regular =SUM(BQ5:BQ20) doesn't work too.

I have a question about your formula in column A. What is it calculating? Why do you work with time like with strings?

Formulas in column A and formulas with UDF function do the calculations for positive and negative times, that why strings.

Re: UDF not working quite good