Spreadsheet: 678252d1589799473-getting-error-in-simple-add-and-subtract-formula-salary-emp_01
Sheet: Staff Salary

Yes
No
 |  | Days Of the Month: |  | 31
 | Minutes In a Day : |  |  | 360 |  |  |  |  | Month - AUG 19
Serial # | Employe # | Names | Join | Days |  |  |  |  |  | Salary |  |  |  |  |  | Last Deposit | Deduction |  |  |  |  |  | Balance Payments | Short H |  |  |  | M.Cs. |  |  |  | Pay Salary
 |  |  |  | Present Days | Leave | One Leaves Allowed | OFF |  | Earned | Last Bonus |  | Basic Salary | Per  Day | Per   Hour | Earned
 |  |  |  |  |  |  | Actual | Twice |  | Date | Amount |  |  |  |  |  | Current Deposit | In & Out | Amount Deductions | Advance Amount | Loan | Pay After Deductions |  | S.H | [NAME]Hours | Amount | Pay After Deductoin & SL | Total - M.Cs. | M.C  Days | Amount | Pay After Deductoin & L.Cs
1 | 6 |  | 2018-07-24 00:00:00 |  |  |  | 0 |  |  | 2018-06-24 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  | Total Days: | 31
2 | 24 |  | 2018-07-25 00:00:00 |  |  |  | 0 |  |  | 2018-06-25 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 1 |  |  |  |  |  |  |  |  |  | Present Days: | 29
3 | 139 |  | 2018-07-26 00:00:00 |  |  |  | 0 |  |  | 2018-06-26 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 2 |  |  |  |  |  |  |  |  |  | Leaves: | 1
4 | 0 |  | 2018-07-27 00:00:00 |  |  |  | 0 |  |  | 2018-06-27 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 3 |  |  |  |  |  |  |  |  |  | One Allowed Leave: | 0
5 | 0 |  | 2018-07-28 00:00:00 |  |  |  | 0 |  |  | 2018-06-28 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 4 |  |  |  |  |  |  |  |  |  | Twice (OFF) | 2
5 | 0 |  | 2018-07-29 00:00:00 |  |  |  | 0 |  |  | 2018-06-29 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 5 |  |  |  |  |  |  |  |  |  | Total Earn Days:
5 | 0 |  | 2018-07-30 00:00:00 |  |  |  | 0 |  |  | 2018-06-30 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 6
5 | 0 |  | 2018-07-31 00:00:00 |  |  |  | 0 |  |  | 2018-07-01 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 7
5 | 0 |  | 2018-08-01 00:00:00 |  |  |  | 0 |  |  | 2018-07-02 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 8
5 | 0 |  | 2018-08-02 00:00:00 |  |  |  | 0 |  |  | 2018-07-03 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 9 |  |  |  |  |  |  |  |  |  | Total Days: | 31
5 | 0 |  | 2018-08-03 00:00:00 |  |  |  | 0 |  |  | 2018-07-04 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 10 |  |  |  |  |  |  |  |  |  | Present Days: | 29
5 | 0 |  | 2018-08-04 00:00:00 |  |  |  | 0 |  |  | 2018-07-05 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 11 |  |  |  |  |  |  |  |  |  | Leaves: | 2
5 | 0 |  | 2018-08-05 00:00:00 |  |  |  | 0 |  |  | 2018-07-06 00:00:00 | 700 | 0 |  |  |  | 11000 |  | 0 | 0 |  |  |  |  | 0 | 0 |  |  | 12 |  |  |  |  |  |  |  |  |  | One Allowed Leave: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Twice (OFF) | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Earn Days: