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.

How to get individual hours to know how much spent each task

Discussion in 'Ask an Excel Question' started by KishorKK, Feb 9, 2019.

  1. KishorKK

    KishorKK Member

    Messages:
    86
    Hi Team,


    Please tell me how to know individual worked hours for each task, i am giving simple.

    Attached Files:

  2. AlanSidman

    AlanSidman Active Member

    Messages:
    446
    See Attached

    Attached Files:

    KishorKK and Thomas Kuriakose like this.
  3. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    648
    Spoilt for choice!
    I am not 'giving simple' :eek:

    Attached Files:

  4. KishorKK

    KishorKK Member

    Messages:
    86
    ha ha actually it's sample, typo error
  5. KishorKK

    KishorKK Member

    Messages:
    86
    Sir Peter, very impressed with ur excel file can u please explain how you did it?
  6. KishorKK

    KishorKK Member

    Messages:
    86
    Thank You Sir, why "h1" cell used, i am not getting
  7. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    648
    Hi. The file I uploaded contains four separate approaches to solving your problem in Excel. The array formula is something I use as a matter of routine but it is not commonly used. In time, it will be largely replaced by the new dynamic arrays of the second solution but, for the moment, that functionality is on beta test.

    The pivot table is the technique of choice for users that live by data analysis (the ones that say 'the solution is a pivot table; what was your problem again' :DD). That, in turn, may be overtaken by Power Query and Power Pivot that build off recent database technologies. These are the third and fourth solutions.

    At present, the only point I was trying to make is that far more exists within Excel than the usual diet of relative cell references and 'copy-down'. Some of the functionality is very good and links the solution back to the problem formulation rather than existing in its own little world of direct single-cell references A1 etc with its voodoo mysteries of anchoring ($A1 versus A$1 :eek:)

    The Excel help pages should assist you.

Share This Page