Multiplying to a maximum value

[MikeDWi]

Hi everyone, I am pretty new to excel formulas and am having difficulty finding the correct formula for the below issue.
I am trying to create a time sheet so I can keep track of my pay, I want to find them sum of (pay rate) x (hours worked). However I only want the cell to multiply to a max of 7.6 hours, so for example say if I work for $10 an hour and I put down in the hours worked column 12 hours I want it to say my standard pay is $76 and not 120, as I have other columns which I will put my overtime hours into to give me a final total (standard pay + oT etc)
Any help would be appreciated

[AliGW]

Welcome to the forum.

Let's say pay rate is in A1 and hours worked in B1.

In C1:

=A1*MIN(7.6,B1)

[MikeDWi]

Thank you so much!!!

[AliGW]

You're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.