Client will be sharing the inputs based on the Time sheet staff has worked, we need to calculate the Overtime and Salary based on the Time sheet, and also we need to bill them based on a fixed rate for both Salary and OT, here I need a Macro can provide the result for Invoice and [login to view URL] me tell one example: Staff has worked 11 hrs on Monday, here 8 hrs is fixed and rest 3 hrs it will be OT, so for billing purpose it will be charged 12/hr, so 8*12= 106 (Salary) and OT (3*1.25*12) 45, So Total Billing: 45+106 = 152. 1.25 will be charged by default for OT, and if the staff is working on Fridays it will be 1.5 instead of 1.25.
44 freelancers are bidding on average ₹1211 for this job
I will dedicate myself fully for this job,and accuracy shall play a major [login to view URL] you in advance. Relevant Skills and Experience A skilled mathematician and a well amoured in terms of data entry.