Formula help - Time Management

[Shazz]

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

[atanuchanda]

Hi Shazz,

I went thru your file and found problem quite easy to fix. Write the formula in Cell I2 =IF(D2="","",SUM(E2-D2+F2)+(G2-H2)-(F2)) and overwrite the cells below with it.

Thanks Atanu.

[CheshireCat]

Hi Shazz,

If the result of a date/time calculation is negative, Excel will display #######.

In I2 you might also try:

=MAX(E2-D2+G2-H2,0)

Copy/autofill down.

Cheers,