1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

take subtotals of production time

Discussion in 'Ask an Excel Question' started by Lasantha, Jan 11, 2018.

  1. Lasantha

    Lasantha Member

    Messages:
    92
    Hi team,

    Could you please help me to take subtotals of column H(Production time).

    i need total production time of each individuals.

    thank you ,
    Lasantha.

    Attached Files:

  2. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    16,619
    Hi ,

    The easiest way is to create a pivot table.

    See the attached file.

    Narayan

    Attached Files:

    Thomas Kuriakose and Lasantha like this.
  3. Lasantha

    Lasantha Member

    Messages:
    92
    Dear Narayan,

    thank you very much for the reply.

    can you please review this again if you have a time. totals are not accurate.

    some individual's total production time is zero(0). but when i checked the details, there is some production time.

    thank you very much for your time.
    Lasantha.

    Attached Files:

  4. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    795
    Alternative for pivot: in the Data tab of the ribbon go to Outline and press on SubTotal.
    But... I've noticed your column H is not formatted as time (might be the problem in the pivot as well). Hence some results are "0".
    When I formatted the column as time and did a text to column it worked.
    upload_2018-1-11_13-11-1.png

    Attached Files:

    Thomas Kuriakose, Lasantha and S. Das like this.
  5. Lasantha

    Lasantha Member

    Messages:
    92
    Hi ,

    thank you very much for this and your time.
    have a nice day.

    Lasantha.
  6. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    16,619
    Hi ,

    The problem was as Guido has already mentioned ; doing a Text to Columns converted all the values to times.

    Another option would have been to replace the static time values in column H with the formula , as shown in the attached file.

    Narayan

    Attached Files:

  7. Lasantha

    Lasantha Member

    Messages:
    92

    Great, thank you very much.
  8. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    795
    just for fun, the option Power Query... No need for a formula. Just define correct data types - Duration - and use a group by with a simple sum column.

    Attached Files:

    Thomas Kuriakose and Lasantha like this.
  9. Lasantha

    Lasantha Member

    Messages:
    92
    thank you @GraH - Guido ,

    can you please give me more details, how to do this.

    Lasantha.
  10. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    795
    My pleasure... Which version of Excel are you using? Power Query is available as from v2010 for windows users. But depending on the version, different ways to get it on the ribbon. You can check out some posts on the topic on the blog or the MS site.
    Once installed/activated on your side, we can exchange some private messages, if you'd need more help afterwards. It is rather easy to start using this.
    Lasantha likes this.
  11. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    16,619

Share This Page