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.
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
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.
Hi Shazz,
If the result of a date/time calculation is negative, Excel will display #######.
In I2 you might also try:
Copy/autofill down.Code:=MAX(E2-D2+G2-H2,0)
Cheers,
Bookmarks