Excel Macro & VB Script

₹600-1500 INR

Completed

Posted

over 4 years ago

₹600-1500 INR

Paid on delivery

Need a Macro/ VB Script which does the following with the attached Excel 1: Sort all records in acending order by Date (Column C) 2: Column E (Distance) - Remove 'M' and then multiply with 3.28. The modified values should be entered at same cell 3: Column O (Timing) - Remove the minutes and mili seconds. Add 600 to the seconds example 01:40:60 will become 600 + 40 = 640 4: Insert new Column Named TD - Divide Column E (Distance) by Column O 5: Insert new Column Named DD - Find the difference between 2 dates of Column C example difference between 01-11-2018 and 06-12-2018 is 35 days

Excel

Excel Macros

Excel VBA

Project ID: 22642872

About the project

3 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@nvchien94

Hello there, I am an Excel expert and I can create VBA macro to do this automation for you. It will take only 20 mins and can start right now. Thank you.

₹1,500 INR in 1 day

5.0

(147 reviews)

5.9

3 freelancers are bidding on average ₹1,467 INR for this job

@vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I can develop a macro to accomplish all 5 points which you described here. I have done many similar Excel VBA Programming jobs. So, can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra

₹2,000 INR in 1 day

4.8

(62 reviews)

5.3

@tauseefnsr

I have worked as a researcher in my previous job profile, where I was working mostly on Excel and doing number crunching. So I have great hands on experience on Excel spreadsheets. I have a strong passion to learn more and do more. In terms of personal attributes, I am an excellent speaker, self-starter, an organised and dedicated worker. I am a person who gives attention to detail in my work.

₹900 INR in 3 days