• 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


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

Need help to construct a formula for Column N and O

Not open for further replies.


New Member
Hello see attached,
Column N and O requires formula
N6 should give 6.5 as result since hours worked should be fully considered on public holidays
N7 should give 6.5+3.5 as result. The 3.5 is obtained by taking into consideration that in a week there was one public holiday and 4 normal days. The employee should have worked (9*4)=36 but has worked ((9*3)+12.5)=39.5.
N8 should give only 0.5 as result as the overtime relates to another employee.
Also Note, overtime eligible per employee in a week with no public holidays is total overtime hours worked minus 5 hours. (45 statutory hours are considered before becoming eligible for overtime)
Please help to edit formula in column N and insert a formula in column O which should generate the total overtime hours per employee per week which the employee will be paid.


  • Overtime Calculation.xlsx
    18.4 KB · Views: 4


Please, do not duplicate Your thread.
Continue with Your original one:
This thread is closed now.
Not open for further replies.