Formula Help - Time Management

Hi All,

I wonder if anyone can help me, Attached is a spreadsheet that i have created for Time Management but I do not know how to get rid of the ######## in Column J & L. Can anyone advise how to do this.

Shazz
xx

In I2 try

Please Login or Register  to view this content.

and pull down as needed.
In the expression SUM(E2-D2+F2) the SUM function is redundant thus unnecessary

This isn't right but it shows you how to approach it.

=IF(E2<>"",(E2-D2+F2),0)+IF(G2<>"",(G2-H2),0)-IF(F2<>"",F2,0)

You need to decide what default values to use when various cells are blank. As it is, you get invalid/negative times which ripple through to the total.


Regards, TMS