Results 1 to 3 of 3

Thread: Formula help - Time Management

  1. #1

    Formula help - Time Management



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    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.

  3. #3
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    Hi Shazz,

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

    In I2 you might also try:

    Code:
    =MAX(E2-D2+G2-H2,0)
    Copy/autofill down.

    Cheers,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •