Search
Search

# How overtime can be calculated based on time and hours both?

Hi Experts,

I have to achieve below mentioned scenarios.

Questions:-

Do I require no.PCR separately for different allowance?

How many time types are required for this?

Which Operation to be used for OT so that I will get time as well as hours of OT? How will I know OT time if client enters approved OT from 17.00 to 00.00, because from 17.00 to 20.00 one rate is applicable and from 20.00 to 00.00 other rate is applicable.

My client is having 5 types of incentives related to OT below are the details.

General Shift timings- 8.00-17.00

Night Shift timing- 20.00- 8.00

1. OT calculation and Allowance based on IT2002

Employee Sub Group- Driver

i. calculation for monday to thursday

a. No OT general shift timings are 8.00- 17.00

b. OT rate 1.5 from >17.00- 20.00

c. OT rate 2 from >20.00- 00.00

d. OT rate 1.5 from >00.00- 8.00

ii. calculation for Friday to Saturday

a. No OT general shift timings are 8.00- 17.00

b. OT rate 1.5 from >17.00- 20.00

c. OT rate 2 from >20.00- 00.00

d. OT rate 3 from >00.00- 8.00 (from mid night saturday to saturday 8.00)

iii. calculation for saturday

a. OT rate 1.5 general shift timings are 8.00- 17.00 (excluding break OT only for 8 hrs)

b. OT rate 3 from >20.00- 08.00

iv. calculation for sunday

a. OT rate 1.5 general shift timings are 8.00- 17.00 (excluding break OT only for 8 hrs)

b. OT rate 3 from >20.00- 00.00

c. OT rate 1.5 from >00.00- 8.00 (from mid night sunday to monday 8.00)

2. Shift Allowance based on IT2011

Night shift- Allowance 200

Rate based on 200 as per working hrs

i. >=7.5 Rate 100%

ii. 7.30 <=Wrk hr<7.50 Rate 93.75%

iii. 4.0 <=Wrk hr<7.30 Rate 50%

iv. Wrk hr < 4.0 Rate 0

3. Food Allowance on IT2002

Work overtime for all shifts

Employee Sub Group- Section

Position- All except Driver

i. OT after shift end >= 1.5hrs- Amount 0

ii. >= 2hrs  OT after shift end < 5 hrs Amount 30

iii. OT after shift end >= 5 hrs Amount 60

iv. OT Clock out >=20:00 Amount 0

Position Driver

i. OT after shift end >= 1.5hrs- Amount 0

ii. >= 2hrs  OT after shift end < 5 hrs Amount 0

iii. OT after shift end >= 5 hrs Amount 0

iv. OT Clock out >=20:00 Amount 30

4. Living Allowance on IT2002

Work overtime for only night shift

Employee Sub Group- Section

Position- All except Driver

a. Allowance for working OT normal day

i. OT after shift end >= 2hrs Amount 30

ii. OT after shift end < 3 hrs Amount 0

iii. OT after shift end >= 3 hrs AMount 0

b.Allowance for working OT holiday day

i. OT after shift end >= 2hrs Amount 30

ii. OT after shift end < 3 hrs Amount 0

iii. OT after shift end >= 3 hrs AMount 0

Position Driver

a. Allowance for working OT normal day

i. OT after shift end >= 2hrs Amount 0

ii. OT after shift end < 3 hrs Amount (30 thb/3Hrs)*Actual wrk hrs **

iii. OT after shift end >= 3 hrs AMount 30

b. Allowance for working OT holiday day

i. OT after shift end >= 2hrs Amount 0

ii. OT after shift end < 3 hrs Amount (30 thb/3Hrs)*Actual wrk hrs **

iii. OT after shift end >= 3 hrs Amount 30

5. Transport allowance

Only for Drivers in all shift

Clock in <= 06::00 Amount 100

Clock out >=22:00 Amount 100

Thanks,

Sneha