Find Jobs
Hire Freelancers

Excel Macro to Create Overtime Entry

$250-750 USD

Suoritettu
Julkaistu yli 5 vuotta sitten

$250-750 USD

Maksettu toimituksen yhteydessä
We download a project report for payroll - see file timesheet report_2018-0805_thru... That file is that copied on to file Construction Tsheets-CRM Transformation and we press CTRL->L for a built in macro to transform into file After Macro Construction Tsheets-CRM Transformation. We need to have the original file timesheet report first mentioned..... have a daily over 8 hours overtime calculation function. We have graphically explained it in file [login to view URL], but essentially we need to calculate overtime daily (over 8 hours daily) for each employee, create a new entry of the overtime with all the same information on the original report, deduct the overtime from the last hours worked for the day. The Macro would need to be compatible with our transformation sheet as mentioned above as it is imported in Microsoft CRM.
Projektin tunnus (ID): 17573023

Tietoa projektista

16 ehdotukset
Etäprojekti
Aktiivinen 6 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
HI, I am good at Excel and VBA Macros. I have referred the files. i would like to discuss it further in the chat and start working on the project. -Chandra
$500 USD 1 päivässä
5,0 (964 arvostelua)
8,1
8,1
16 freelancers are bidding on average $344 USD for this job
Käyttäjän avatar
Dear Client, I have thoroughly studied the files. I have good knowledge in excel and vba progrramming. I invite you to contact me so that we have a discussion regarding the project. Hope to hear from you. Thanks Roy
$300 USD 4 päivässä
4,9 (432 arvostelua)
7,1
7,1
Käyttäjän avatar
My expertise and skills are well-suited for your project’s requirements. I am a financial expert and a guru in Excel and VBA. I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. Also, I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. I develop financial modules and financial projections including business valuation & terminal valuation methodology & ratios. I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in Financial Reports, accounting, consolidating, forecasting, budgeting, and costing I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation. During my career, I have gained valuable experience in diverse sectors, including VC’s, private investors, start-ups, retailers, power plants, farms, insurance companies, universities, construction businesses, real estate agents, medical equipment manufacturers, and traders, among others.
$750 USD 10 päivässä
4,9 (92 arvostelua)
7,2
7,2
Käyttäjän avatar
Hello, I have read your project description. You can check my freelancer portfolios and my reviews for my previous top quality work I am very interested in your project and also I am ready to start immediately. I will give you high quality and fast work and continue working till the time you are satisfied. Thanks & Regards.
$500 USD 10 päivässä
4,9 (131 arvostelua)
7,1
7,1
Käyttäjän avatar
HI, The process can be done through this way. First using Pivot table, it will be calculated total numbers of hours worked on any particual day by employee. Then looping only those with overtime will be looped and required operation will be done. I will also create a report of in easy to check Table way. There are couple of chellenges I see. In time, there may be entry if Over time higher then number of hours in Last entry. That way, previous entry will need to manage? I have completed over 150 related projects here. Start and and Time for over time entry..and end time of entry from which hours are deducted. Will that need to be managed also? We shall discuss these points in detail. I am expert in Excel VBA and I can complete this process within couple of hours. Thanks
$260 USD 2 päivässä
4,9 (303 arvostelua)
6,9
6,9
Käyttäjän avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Sure. Let me do it. Willing to take up your project. Thank you, Regards.
$300 USD 3 päivässä
5,0 (134 arvostelua)
6,6
6,6
Käyttäjän avatar
Hi, As you want development of Overtime calculator, I will design the same for you using Excel functions and VBA macros. I will give you high quality product. Please give me this opportunity to do this work. Thanks, Mohan
$250 USD 5 päivässä
5,0 (91 arvostelua)
6,2
6,2
Käyttäjän avatar
Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL 100% Satisfaction Of Deliverable
$250 USD 2 päivässä
4,9 (78 arvostelua)
5,9
5,9
Käyttäjän avatar
Hi, Good Day! I am a PMO Analyst and my primary task is the creation of Financial Reports. I am exposed on different excel formulas and functions. I am also a VBA Macro developer which I think a big plus to complete this project. You can check my reviews to help you decide. Feel free to message me anytime to discuss this project. Thank you
$250 USD 3 päivässä
4,9 (48 arvostelua)
4,8
4,8
Käyttäjän avatar
Hi i read your description and gone through your attachments, and i am sure i can handle your request. I have 10+ years of experience in Advance Excel, VBA, Macros and other office integration development
$333 USD 5 päivässä
5,0 (10 arvostelua)
4,2
4,2
Käyttäjän avatar
Dear Sir, I went through your project description and sample files. I can develop the solution as you described and i'll assure to work with you till your requirement fulfill. Kindly contact me. Thank You.
$250 USD 10 päivässä
5,0 (4 arvostelua)
2,9
2,9
Käyttäjän avatar
Hi There! I am an excel Expert with hands-on experience in Macros. I can complete this task with great results. Please inbox me for further details. Kind regards, Toqeer Ahmad
$555 USD 10 päivässä
0,0 (0 arvostelua)
0,8
0,8
Käyttäjän avatar
I have skills to create documents in excel, that facilitate the work, according to the understanding you need a sheet that calculates the extra time
$250 USD 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Hey, I'm interested in your project. Please send me a message so that we can discuss more.
$250 USD 3 päivässä
5,0 (1 arvostelu)
0,1
0,1

Tietoja asiakkaasta

Maan UNITED STATES lippu
San Diego, United States
5,0
1
Maksutapa vahvistettu
Liittynyt elok. 14, 2018

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.