software

I am working a data sheet with start/finish dates from which the bosses want
charts made etc. If I don't have a finish date, I get a massive negative
number, which skews everything. Plus the formula I am using for working
hours leaves me with a quot;-8quot; in every form block that has not yet had data
entered. Is there a way to suppress these negative numbers without affecting
format?

you could wrap your formulas like this to output 0 instead of negative numbers

=Max(formula,0)

or this will output a blank space (which is ignored by SUM and AVERAGE)

=IF(formulalt;0,quot;quot;,formula)

quot;kimdnwquot; wrote:

gt; I am working a data sheet with start/finish dates from which the bosses want
gt; charts made etc. If I don't have a finish date, I get a massive negative
gt; number, which skews everything. Plus the formula I am using for working
gt; hours leaves me with a quot;-8quot; in every form block that has not yet had data
gt; entered. Is there a way to suppress these negative numbers without affecting
gt; format?

OK, so my existing formula is:
=(NETWORKDAYS(Start,Finish, Holiday)-1)*8 (MOD(D3,1)-MOD(C3,1))*24
based on an 8 hour work day and a 24 hour clock

New formula is:
=MAX((NETWORKDAYS(C3,D3, A44:A60)-1)*8 (MOD(D3,1)-MOD(C3,1))*24,0)

Seems to work! Thanks Sloth!

Kimdnw

quot;Slothquot; wrote:

gt; you could wrap your formulas like this to output 0 instead of negative numbers
gt;
gt; =Max(formula,0)
gt;
gt; or this will output a blank space (which is ignored by SUM and AVERAGE)
gt;
gt; =IF(formulalt;0,quot;quot;,formula)
gt;