How to create a formula in excel with a threshold. For example overtime pay for hours over 40?

Kristina B asked:

Creating a spreadsheet that shows employees and hours worked for a period then in another column calculates pay both regular and overtime. Need to create a function in the overtime pay column which will calculate any hours over 40 at 1.5 (given in the assumption.

new site

Leave a Reply

Your email address will not be published. Required fields are marked *