• 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...

  • 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

kamashal

New Member
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?
 

Attachments

  • Calculation.xlsx
    33.3 KB · Views: 6
kamashal
Interesting 'rules' ...
You didn't explain some of Your used terms ... I gotta guess.
... something like this?
 

Attachments

  • Calculation.xlsb
    66.2 KB · Views: 4
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.
 
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.
 
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 ;)
 

Attachments

  • Calculation.xlsb
    69.3 KB · Views: 1
Back
Top