Excel expert to split overall timeframe into hourly contributions
$30-250 USD
S-au achitat serviciile după ce au fost prestate
Need excel formula to process multiple timeframes and split them into hourly contributions. The requirement is to determine the number of minutes within each hour that the timeframe covers. See example below. Start and Stop time will be known, formulas required to calculate minute contribution per hour. In the first example, for the timeframe 07:12 (start) to 09:18 (Stop), 48 minutes are in the 07:00 to 08:00 timeframe, 60 minutes in the 08:00 to 09:00 timeframe and 18 minutes in the 09:00 to 10:00 timeframe.
Timeframe Hourly Contributions
Start Stop 7:00 8:00 9:00 10:00
7:12 9:18 0:48 1:00 0:18 0:00
7:20 7:48 0:28 0:00 0:00 0:00
8:20 9:10 0:00 0:40 0:10 0:00
I need the ability to process multiple start-stop times.
ID Proiect: #16530533
Detalii despre proiect
Acordat lui:
Hi there, Your project is very interesting and I think given my experience with this type of work that I would make a great fit. I have over 15 years of corporate experience working in Excel creating advanced automa Mai multe
46 freelanceri plasează o ofertă medie de 92$ pentru proiect
Hi there..... Warm Greetings We came along with your request for split overall timeframe into hourly contributions and we reviewed your project description. We'd like to help you with confidence and satisfying re Mai multe
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Dear Sir/Madam, As one of the trusted excel experts in this site, I;m happy to help you on this task. Please refer my profile to see my qualifications, experience and reliability, and if you are comfortable with thos Mai multe
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twelve excel vba projects in the past three months. Willing to take up your project. Thank you, Regards.
I am an Excel expert and can create an easy to use sheet for this timeframe split timings calculations.
Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can dev Mai multe
I am an Excel specialist. I am confident that I csn create the formula you need and if necessary I can also create a macro as per your requirements.
Hello, I can create a macro that will run exactly as described and you can have multiple start-stop. You will just need to press a button. Nothing else. Please open a chat with me if you are interested. Kind Mai multe
I have a lot experience in Excel and I can help you in this field. Thank for the opportunity.
Hi there, I can do it right away, if you send me the file. (Before awarding me) Drop me a line, I'm online right now. I just need to know how many splits do you need. Best, M.Sijarrey.
I think I can help you on your project. I believe that I can solve your project with VBA or formulas, which you prefer. Feel free to contact me to discuss any further details, my bid and deadlines. Best regards.
Experienced Excel/Word user based in Brisbane, Australia, with office and technical background. Good with maths, spreadsheet functions, and macros. Native English speaker fluent in US and UK English. .
Hello, I'm a reporting analysts at a contact center with timeframes of 15 to 30 minutes, I can help you with this formula and I will build you a pivot table to easily control de total time by every tineframe.
Have been working as reporting analyst from past 5 years. Am using excel from past 5 years. i can complete the task in given time limit.