Calculation formula greater than less than

Hi Experts,
I'm looking formula in D column to calculate according the criteria, Example:

In this example I need Cell D2 to be:
-up to the first 40 hours is $10.00 per hour in this example-anything over 40 hours (7 in this example) is paid 1.5 times the hourly pay of $10
-So the total for cell D2 needs to be: (40*10)+(7*15)=505


I want the same formula for cell D2 that will work in D3 as well where there is no amount over 40 hours. So D3 will be (36*11)+(0*16.5)=396

Thanks in Advance.
gul

Hi 65string, Thanks for help, but result is not correct, when I put your formula in 1st it is showing 575 but it would be 505

In this example I need Cell D2 to be:
-up to the first 40 hours is $10.00 per hour in this example-anything over 40 hours (7 in this example) is paid 1.5 times the hourly pay of $10
-So the total for cell D2 needs to be: (40*10)+(7*15)=505


I want the same formula for cell D2 that will work in D3 as well where there is no amount over 40 hours. So D3 will be (36*11)+(0*16.5)=396

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Sorry, here is Sample excel file

Please explain your example
in B2 the total hours are 58. So 40 regular hours at 10 =400.
Ouverhours =58-40=18 and 18*15=270
Total = 670
Where do you get the 7 overhours instead of 18???

Thanks rorya, you are Expert.