On Monday, February 3, 2014 10:07:40 PM UTC+5:30, Auric__ wrote:
gojakiego wrote:



On Friday, January 24, 2014 6:36:42 PM UTC+5:30,

wrote:

Dear Friends,



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

please help



http://www.mrexcel.com/forum/excel-q...-based-hours-r

ate-designation.html



Thank you



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.



--

Brain gone bad.

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