Skip to Content

Average Rate for OT payment


OT to be paid to employee based on rate from their quarterly average of basic salary and quarterly average of Working hours.

Condition 1: Once OT rate is formed for a quarter, it should not recalculate in retro in case of salary hike or working hrs changes.

Condition2: In case of arrear payable , those amount should be added in respective quarter and no recalculation in retro quarter months.


Jan-19 Basic salary - 50000 _ Working hours 82.80 hrs

Feb-19 Basic salary - 50000_ Working hours 82.80 hrs

Mar-19 Basic salary - 50000_ Working hours 82.80 hrs

Average calculation:

Jan+Feb+Mar salary / 3 = 50000+50000+50000 /3 = 150000/3 = 50000

Jan+Feb+Mar whr/ 3 = 82.80+82.80+82.80/3 = 248.4/3 = 82.80

OT rate of First quarter should be 50000/82.80 = 603.86 (no revision in this rate 603.86 should happen in retro)

In may19, Jun and Jul19, if employer wants to pay OT, the rate to calculate OT should be 603.86 of first quarter.

The above calculation applicable for subsequent quarter.

We tried AVERA function and its configuration, its recalculating the frozen average rate while paying arrears which should not be the case in this requirement.

Please suggest a solution.


Velvendhan D.

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.