Closed

Excel Macro for Salary/Overtime based on Time sheets - Invoice and Payout

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.

Skills: Excel, Visual Basic, Data Processing, Data Entry, Visual Basic for Apps

See more: excel macro cut paste based cell value, macro search website based cell content excel, excel macro print invoice number, excel macro charge fee based time, excel macro selecting sheets print, input salaries time sheets excel spreadsheets, excel macro pastes data time, excel macro time difference, lock excel field based time day, excel macro cut paste based column value, excel macro insert date and time in cell, excel macro insert picture based on cell value, excel macro rearrange columns based on header, excel macro rename file based on cell value, excel macro salary

About the Employer:
( 0 reviews ) India

Project ID: #22354507

46 freelancers are bidding on average ₹1212 for this job

finecodervw

Hi, Let me introduce myself as an expert Excel macro programmer. I have used macros extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in Excel macro work. It includ More

₹1500 INR in 3 days
(82 Reviews)
5.7
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can develop Excel VBA (Macro) to calculate salary and overtime as per your requirements. I ha More

₹2500 INR in 2 days
(98 Reviews)
5.7
palinco2003

Good day, I am Paul, a professional web research and excel sheet data expert. I have read your order details. And really understand the data and information you want. I have helped other clients with similar tasks to More

₹3200 INR in 3 days
(15 Reviews)
4.3
sharmapritam311

Hi there. I have built similar solutions in the recent past. I have done several projects in VBA from small to large.

₹2050 INR in 1 day
(6 Reviews)
2.6
ArunTindu

Dear Client, Job description is understood well and able to know what you are expecting in the macro. I can create this macro as per your concern. Already done some macro in my previous jobs. Good skill in excel and VB More

₹850 INR in 2 days
(2 Reviews)
1.0
muhammadqasim321

Hello, my name is Muhammad Qasim. I am a dedicated and hard working person who believes in honesty and good working relation. Though I am new at this sector of job but I've certain qualities which makes me good at this More

₹600 INR in 3 days
(0 Reviews)
0.0
chandrakishore95

I am experienced in data entry job, i have worked on data entry for 3months Relevant Skills and Experience Data entry , typing

₹700 INR in 3 days
(0 Reviews)
0.0
snbohare

Hands on experience on Payroll for approx 15 + years and command on MS office can create and make payrolls in a day time.

₹1250 INR in 2 days
(0 Reviews)
0.0
azizayoubi

Hello, I am Aziz Ayoubi, MS Excel and Access expert with more than 7 years experience, VBA and C# programmer and IT troubleshooting master. I am also a structural engineer who masters analysing software ETABS, Robot an More

₹600 INR in 1 day
(0 Reviews)
0.0
₹1300 INR in 1 day
(0 Reviews)
0.0
padma1027

Highly focused and committed International HR professional with 7+ years of experience in HR- Coordination. Looking for a challenging role in a fast paced, professional work environment and contribute significantly to More

₹1050 INR in 7 days
(0 Reviews)
0.0
shyam15agrawal

I am interested in your project. I am familiar with MS Excel's functions for fast work and accurate. It means you have not to worry about the outcome of if you are hiring me. My work is not just finished your individua More

₹600 INR in 7 days
(0 Reviews)
0.0
manubhai564

Hire me

₹1300 INR in 1 day
(0 Reviews)
0.0
amnag489

I Am good Web developer and ui do this project nicely.. Give me this project. Ready to work with you

₹600 INR in 4 days
(0 Reviews)
0.0
doha1960

I am retired engineer experienced Relevant Skills and Experience I have worked as project Manager and controled more than 80 staff preapared attendence sheets and filled the over time sheets and handled manpower effec More

₹1300 INR in 3 days
(0 Reviews)
0.0
roopakjayakumar

I am truely excited to be working with you and look forward to your response. I expert in ms excel ,word,data [login to view URL] to exel

₹1050 INR in 7 days
(0 Reviews)
0.0
gordonkoross

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.

₹1300 INR in 3 days
(0 Reviews)
0.0
Chethank205

Good to get the project Relevant Skills and Experience 6 Years experience in payroll

₹1300 INR in 1 day
(0 Reviews)
0.0
sidraamjad0307

I will do any data entry in excel job I will interested your work

₹1300 INR in 2 days
(0 Reviews)
0.0
rb1919717

I have 2 years experience as a data encoder in a big local power distributor company and 3 years experience as a Virtual Assistant. In the course of time, I have developed my skills in email handling, web research, dat More

₹1200 INR in 5 days
(0 Reviews)
0.0