Payment calculation

[gojakiego]

I dont know how to display my sheet here. However, I will try to show the sheet in text format.

There are two criteria where I am unable to write a formula and need help. I want to update the Payout column with a formula based on number of hours worked by the employee and also based on their role/designation. Need formulas in range E11:E20 Please help !

Below is how my data looks like in the range B2:E20. Cell B2 and C2 are merged and Cell D2 and E2 are merged.

B2->Hours
B3->From
B4->00:00
B5->50:01
B6->75:01
B7->85:00
B8->95:01
B9-> <blank>
B10->Employee
B11->Emp1
B12->Emp2
B13->Emp3
B14->Emp4
B15->Emp5
B16->Emp6
B17->Emp7
B18->Emp8
B19->Emp9
B20->Emp10

C2->
C3->To
C4->50:00
C5->75:00
C6->85:00
C7->95:00
C8->150:00
C9-> <blank>
C10->Role
C11->Manager
C12->Manager
C13->Officer
C14->Manager
C15->Officer
C16->Manager
C17->Officer
C18->Officer
C19->Officer
C20->Manager

D2->Rate
D3->Manager
D4->100
D5->125
D6->150
D7->175
D8->200
D9-> <blank>
D10->Hours
D11->52:52
D12->101:23
D13->00:00
D14->76:09
D15->44:25
D16->75:00
D17->85:00
D18->93:39
D19->111:53
D20->80:11

E2->
E3->Officer
E4->150
E5->180
E6->210
E7->240
E8->270
E9-> <blank>
E10->Payout
E11-> <blank>
E12-> <blank>
E13-> <blank>
E14-> <blank>
E15-> <blank>
E16-> <blank>
E17-> <blank>
E18-> <blank>
E19-> <blank>
E20-> <blank>

Thank you

 

[MyVeryOwnSelf]

There are two criteria where I am unable to write a formula and

need help. I want to update the Payout column with a formula
based on number of hours worked by the employee and also based
on their role/designation. Need formulas in range E11:E20

My attempt and posted it at
http://zvkmpw.home.comcast.net/Payment_calculation.xls

The worksheet includes an explanation of how the calculation works.

Check that it gets the results you expect.

Hope this helps getting started.