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.

Need Help on the Excel Spreadsheet

Discussion in 'Ask an Excel Question' started by kamashal, Feb 13, 2019.

  1. kamashal

    kamashal New Member

    Messages:
    3
    This is little complicated and i need desperate help from someone..

    In the schedule sheet i have schedule date and Overtime hours. Wherever the hours are updated (hh:mm:ss) it means associates worked for 9 hours.

    In the Overtime columns those are actual over time worked by the associate.

    In the reports sheet, whenever i select from and to date, associate total hours should reflect eliminating Absent (A), Planned leave (PL) and off hours. Total hours will be 9 hours working hours and it should add the over time hours.

    Can some help on this please?

    Attached Files:

  2. vletm

    vletm Excel Ninja

    Messages:
    4,793
    kamashal
    Interesting 'rules' ...
    You didn't explain some of Your used terms ... I gotta guess.
    ... something like this?

    Attached Files:

    kamashal likes this.
  3. kamashal

    kamashal New Member

    Messages:
    3
    Hi Vletm,

    This is what i expected. thank you so much. I did not see any formulas or VBA codes in the excel sheet. Could you please explain where it is hidden? I want to replicate the same in other excel sheets too.
  4. vletm

    vletm Excel Ninja

    Messages:
    4,793
    kamashal
    You can find those codes from Sheet2's code-page.
    Good luck.
  5. kamashal

    kamashal New Member

    Messages:
    3
    thank you vletm. You are great. One more thing. If i need to minus some hours in the sheet, how can do that? For example instead of adding one hours in the Overtime, i need to minus 2 hours.
  6. vletm

    vletm Excel Ninja

    Messages:
    4,793
    kamashal
    So far, there are not possible to do negative overtime hours.
    If really need to do so ... hmm?
    ... then You could handle those with this
    Test that 'logic' Yourself ;)

    Attached Files:

  7. AlanSidman

    AlanSidman Active Member

    Messages:
    445

Share This Page