If overtime is worked then it is the overtime rate plus 10% of the hourly rate. I have put a column in the spreadsheet for the 10% amount and I have tried to add it on but when there are no entries in the spreadsheet it is showing the 10% amount still.
Is there a simple solution to that to show zero if there is no overtime amounts?
Spreadsheet has calculation as follows to calculate Normal, Time 1/2 & Double Time
=SUM(AE13*B13)+(AF13*B13*1.5)+(AG13*B13*2)
For Time and 1/2 and Double time I need it to add 10% of normal wage amount - eg: $17.30 is hourly so $1.73 needs to be added to the Overtime payments total.
When I try to add it on it always shows the amount of $1.73 in the column even when there is no overtime.
Any help would be much appreciated.
Bookmarks