Write a repeatable script to extract key timsheet data from excel file
$30-250 NZD
Paid on delivery
I have an ERP system we use for time recording for our technicians. It does not integrate with our payroll system, so I need to extract key data from the timeclocking output data to import into our payroll system.
For each employee there will be multiple entries for each day depending on what jobs they were working on, but for payroll I only need
1. Start time
2. Start Break
3. End Beak
4. Finish time.
This data is all in the file created by the ERP (copy attached), But i need a script written that will search for and return this data in a csv file.
While the output layout is the same each time, the number of lines per day will vary
The script will need to identify the employee, identify for each day the data above and return it in a csv file.
This is repeated every fortnight
If there are multiple breaks in a day, it needs to exclude any reak less than 10 inutes - not sure if that is possible
Project ID: #37222748
About the project
Awarded to:
23 freelancers are bidding on average $113 for this job
Greetings, I am an Advanced Level Excel Formula, VBA & Macros expert and an Accountant. I am very confident to start your project and complete it with all the efficiency you are looking for. I understand the requiremen More
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Exc More
Hi There, Ready right now I'm ready to Write a repeatable script to extract key time sheet data from excel file. I will show you sample for your satisfaction and project accuracy then we will go to start, so please c More
Hello, I am excited to present my proposal for your ERP system integration project, which aims to streamline the transfer of crucial time recording data into your payroll system. To achieve this seamless integration, More
Hello, I have good experience in writing scripts for various daily routine jobs. I will able to do this, Please let me know if I can share solution with you. Thanks. Regards, Shashi
Hi, I checked your requirement, I can work on it. I have Experience in below technical work. 1. Power Bi Desktop & Services With DAX, Power Editor 2. Excel VBA, 3. Power Query, Power Pivot 4. Advance Excel, 5. Exc More
Hello, I'm Tutul Kumar and I understand that you need a repeatable script to extract key timsheet data from an excel file. With my extensive experience in data entry, data analysis, MS Power BI, Excel Dashboard, data More
GET YOUR WORK IN LOWEST BUDGET BEFORE DEADLINE...............................................................................I hold a Masters degree which gives me the requisite background to handle writing from variou More
I understand that you are looking for someone to write a repeatable script to extract key timsheet data from an excel file. With my background in mechanical engineering and computer technology, I am confident that I ca More
Hello sir/ madam. I reviewed your project description. I am capable of performing various tasks in typing with complete accuracy and am prepared to commence right now. If you're interested, please message me so we ca More
Hello sir/ madam. I reviewed your project description. I am capable of performing various tasks in typing with complete accuracy and am prepared to commence right now. If you're interested, please message me so we ca More
Hi, My name is Mahmoud Saied, I've read your task and I understand that you need to employees start time, end time, and breaks greater than 10 minutes from the attached spreadsheet and export it to another Excel spr More