Results 1 to 3 of 3

Thread: sum answer is not right ?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2009
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default sum answer is not right ?

    hi trying to set up a job sheet template to keep track of hours and materials on the job can get the material side of things sorted ok item cost quantity and total all add up fine . but when i try sum to add up the hours worked on the job it comes up with the wrong answer ? is there a way to attach the speadsheet so you might be able to see where im going wrong ?

    thanks in advance

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,514
    Post Thanks / Like
    Mentioned
    46 Post(s)
    Tagged
    6 Thread(s)

    Default Re: sum answer is not right ?

    Welcome to the forum.

    If you are summing up hours, you may simply need to format the cell with a custom number format of [h]:mm so that it will display times over 24 hours.

  3. #3
    New Member
    Join Date
    Dec 2009
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: sum answer is not right ?

    thank you so much for your help much appreciated

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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