Tom’s Tutorials For Excel: Calculating Salary Overtime
The picture shows how you can set up a worksheet to calculate weekly salaries for your employees, considering hourly wages and overtime hours.
The formula in cell D5 that was copied down to cell D12 is
=IF(B5<=$B$1,B5*C5,SUM((B5-$B$1)*$B$2,$B$1)*C5)
how to find ovetime
Please elaborate; it’s not clear what you are asking about exactly.