hey guys I am trying to create a spreadsheet for my company's payroll but problem I am having is that I want a cell that shows overtime hours earned. So my formula is =G4-40 but if there is 0 hours then it shows -40, how do you make it so it just shows 0 or an empty cell.
So if joe has 43 hours and john has 38,
Code:
Name Hours Overtime Hours
Joe 43 3
John 38 0 (but it shows as -40 not 0)
thanks guys I hope that was clear enough to understand.