1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Resolved Excel not adding correctly, good excel user stumped!

Discussion in 'Other PC Software' started by daveguentherwsd, 2012/09/17.

  1. 2012/09/17
    daveguentherwsd

    daveguentherwsd Inactive Thread Starter

    Joined:
    2012/09/17
    Messages:
    4
    Likes Received:
    0
    daveguentherwsd,
    #1
  2. 2012/09/17
    Steve R Jones

    Steve R Jones SuperGeek Staff

    Joined:
    2001/12/30
    Messages:
    12,317
    Likes Received:
    252
    Welcome to WindowsBBS;)

    Is the spreadsheet clearly marked as to which column adds correctly?
     
    Steve R Jones,
    #2


  3. to hide this advert.

  4. 2012/09/17
    daveguentherwsd

    daveguentherwsd Inactive Thread Starter

    Joined:
    2012/09/17
    Messages:
    4
    Likes Received:
    0
    Sorry, i forgot to add that!
    B 17 Adds correctly
    E 17 Does not, it should be :30 more than B 17
     
    daveguentherwsd,
    #3
  5. 2012/09/17
    daveguentherwsd

    daveguentherwsd Inactive Thread Starter

    Joined:
    2012/09/17
    Messages:
    4
    Likes Received:
    0
    Was given the solution,
    "Format the cell as Custom [h]:mm:ss" This solved my problem
     
    daveguentherwsd,
    #4
  6. 2012/09/17
    Steve R Jones

    Steve R Jones SuperGeek Staff

    Joined:
    2001/12/30
    Messages:
    12,317
    Likes Received:
    252
    I looked at it a little.
    Do you really want an @sum for a bunch of 5:05am numbers? What would you do with them/the total number?
     
    Steve R Jones,
    #5
  7. 2012/09/17
    daveguentherwsd

    daveguentherwsd Inactive Thread Starter

    Joined:
    2012/09/17
    Messages:
    4
    Likes Received:
    0
    5:05:00 AM is representative of time worked 5hr 5min
    Would you suggest a better cell format?
     
    daveguentherwsd,
    #6

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...