Excel Macro to Create Overtime Entry

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.

Taidot: tietojenkäsittely, Excel, tietojärjestelmäarkkitehtuuri, Visual Basic, Visual Basic for Apps

Näytä lisää: excel timesheet formula, excel vba timesheet form, excel formula to calculate hours worked and overtime, overtime tracker excel, how to calculate overtime hours in excel formula, timesheet calculator excel, excel timesheet template with formulas, how to create a timesheet in excel, write entry microsoft word, create booking calendar microsoft access website, kinds data entry microsoft excel, create gpa calculator microsoft excel 2007, create live update microsoft excel tradestation, types data entry microsoft excel, excel data entry work download, entry microsoft excel, create contact list microsoft excel, create pdf worksheet macro excel 2010, excel data entry microsoft word, excel create invoice using microsoft access

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #17573023

Myönnetty käyttäjälle:


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ä
(772 Arvostelua)

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 a Lisää

$260 USD 2 päivässä
(249 arvostelua)

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 Ro Lisää

$300 USD 4 päivässä
(258 arvostelua)

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 an Lisää

$750 USD 10 päivässä
(54 arvostelua)

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 Lisää

$500 USD 10 päivässä
(113 arvostelua)

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 Lisää

$250 USD 2 päivässä
(71 arvostelua)

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, Re Lisää

$300 USD 3 päivässä
(49 arvostelua)

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. Than Lisää

$250 USD 5 päivässä
(33 arvostelua)

i can send first draft for your test within 3-4 days, please clarify possible next steps

$555 USD 7 päivässä
(20 arvostelua)
$250 USD 1 päivässä
(34 arvostelua)

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ä
(4 arvostelua)

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 compl Lisää

$250 USD 3 päivässä
(4 arvostelua)

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ä
(3 arvostelua)

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 arvostelua)
$250 USD 1 päivässä
(0 arvostelua)

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 arvostelua)

Hey, I'm interested in your project. Please send me a message so t Lisää

$250 USD 3 päivässä
(1 arvostelu)