Tom’s Tutorials For Excel: Calculating Salary Overtime

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)

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,
2 comments on “Tom’s Tutorials For Excel: Calculating Salary Overtime
  1. Hamid Fidah says:

    how to find ovetime

Leave a Reply to Tom Urtis Cancel reply

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

*