Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > Payout based on hours rate and designation
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 6
Default Payout based on hours rate and designation
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...signation.html

Thank you
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 6
Default Payout based on hours rate and designation
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...signation.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
Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 6
Default Payout based on hours rate and designation
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...signation.html



Thank you

No replies from anywhere. Please help !
Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 538
Default Payout based on hours rate and designation
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.
Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 6
Default Payout based on hours rate and designation
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-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
Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 6
Default Payout based on hours rate and designation
On Tuesday, February 4, 2014 12:36:53 AM UTC+5:30, wrote:
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.
Reply With QuoteReply With Quote
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 6
Default Payout based on hours rate and designation
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
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
using hours to multiply rate tikchye_oldLearner57 Excel Discussion (Misc queries) 2 February 1st 07 03:10 AM
How do i multiply an hourly rate by hours in Excel? Rackenford. Excel Discussion (Misc queries) 2 July 2nd 06 03:52 PM
Hourly rate times hours? L Excel Worksheet Functions 1 May 8th 06 06:27 PM
How do I calculate total hours by rate of pay? FrankF Excel Worksheet Functions 1 August 16th 05 11:18 PM
How can I work out how many hours I get premium rate? HappyTrucker Excel Worksheet Functions 4 August 7th 05 07:39 AM


All times are GMT +1. The time now is 01:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement