I have two excel files with data (2018 & 2019). The file format is a single line for every incoming call received in 2018 and 2019. Each line indicated the amount of time the call lasted (handle time) and whether the call was "connected" or "abandoned". I need the data converted to show the total # of calls (line items) which arrived and for every 15 minute interval and then the average handle time for each interval (this will require averaging the "handle time" column for each of the rows within the 15 minute interval. Also would need the total number of "abandoned" calls for each interval.
In addition I would need to have an additional 15 seconds added to the "handle time" for each line item. AFTER the 15 seconds are added, then you would average the resulting "handle time" for the interval.
As mentioned, I have one file for 2018 (57,398 lines of data) and another file for 2019 (52,537 lines of data)
45 freelancere byder i gennemsnit $201 på dette job
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
I'm very much interested to help you working on this task you having right now. I'm capable to start work it today and complete in any time your required it. Message me now here. thanks!
Hello there, I have read your project descriptions and can do the work. Please come to chat and have discussion in details about your work. Looking forward, Thanks~
Hi There, I can help you to merged excel file and make the results, i have read your description, i have many experience using excel formulas over 10 years, please kindly check my profile. thanks. regards.