Payout based on hours rate and designation

[gojakiego]

Dear Friends,
I have posted a question on mrexcel for which i am awaiting an answer. please help

http://www.mrexcel.com/forum/excel-questions/752357-payout-based-hours-rate-designation.html

Thank you

 

[gojakiego]

Dear Friends,

I have posted a question on mrexcel for which i am awaiting an answer. please help



http://www.mrexcel.com/forum/excel-questions/752357-payout-based-hours-rate-designation.html



Thank you

Please help me with my query. I cannot display the worksheet contents here and therefore sent a link to it which was posted on mrexcel.com

Thank you

 

[gojakiego]

Dear Friends,

I have posted a question on mrexcel for which i am awaiting an answer. please help



http://www.mrexcel.com/forum/excel-questions/752357-payout-based-hours-rate-designation.html



Thank you

No replies from anywhere. Please help !

 

[Auric__]

No replies from anywhere. Please help !

Why don't you try actually asking your question here? That has a higher
chance of getting a response than "question over there ->" does.

 

[gojakiego]

gojakiego wrote:






Why don't you try actually asking your question here? That has a higher

chance of getting a response than "question over there ->" does.

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->2400:00
D5->3000:00
D6->3600:00
D7->4200:00
D8->4800:00
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->3600:00
E5->4320:00
E6->5040:00
E7->5760:00
E8->6480:00
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

 

[gojakiego]

I dont know how to display my sheet here. However, I will try to show thesheet 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->2400:00

D5->3000:00

D6->3600:00

D7->4200:00

D8->4800:00

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->3600:00

E5->4320:00

E6->5040:00

E7->5760:00

E8->6480:00

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

Sorry... I goofed up a bit in formatting.
The actual data in M4:M8 is:
D4->100
D5->125
D6->150
D7->175
D8->200

and N4:N8 is
E4->150
E5->180
E6->210
E7->240
E8->270

 

[gojakiego]

gojakiego wrote:






Why don't you try actually asking your question here? That has a higher

chance of getting a response than "question over there ->" does.

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