How to count a time value only on a PPH if the employee worked on a time sheet?

[Albert Dirk]

Good day all,

Okay I have created a timesheet for our LDC staff. What I need the timesheet to do automatically is that on a PPH day excel must add 0.3 hours worked for that day in the PPH column and then in the Total Hours column it must count the following columns “Hours + OT1 + OT2 + OT3 - Lunch Time” and the formula must work if the employee is working day or night shift.

So OT1 is if the employee works 8 hours and more then he must receive 0.5 of the day hours in the OT1 Column.
OT2 the employee must receive the same hours he worked for that day in the OT2 Column but only if the employee worked on that Sunday .
OT3 the employee must receive 1.5 of the day hours worked on the public holiday (PPH) in the OT3 Column.

[mikeTRON]

YIKES, why so many merged cells?
You have 13 columns but you have merged together 126 of them. That is terrible.

What exactly are you wanting help with?
I see formulas in the columns merged together for OT1, OT2 and OT3.

[Albert Dirk]

I need OT 3 to show 1.3 of the hours worked if that employee worked on a public holiday (otherwise not show anything) and then the total hours must count the following columns as follows (hours+OT1+OT2+OT3-lunch).

The company I work for is making us use all those merged cells it’s there template.

[mikeTRON]

Can you provide some concrete examples so I can see what you are trying to do?
Then be sure to tell your company they are foolish with those merged cells.