Excel Macro & VB Script

₹600-1500 INR

Abgeschlossen

Veröffentlicht

vor mehr als 4 Jahren

₹600-1500 INR

Bezahlt bei Lieferung

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

Projekt-ID: 22642872

Über das Projekt

3 Vorschläge

Remote Projekt

Aktiv vor 4 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

Vergeben an:

@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 Tag

5,0

(147 Bewertungen)

5,9

3 Freelancer bieten im Durchschnitt ₹1.467 INR für diesen Auftrag

@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 Tag

4,8

(62 Bewertungen)

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 Tagen