=SUM(ADD) ONLY WORKHOURS TO DATE COMPLEX FORMULA
$140-450 MXN
Pago na entrega
I work in a factory with CNC machines.
Work hours are 06:20 AM to 01:05 AM, 18 hours a day.
I need a formula where I can add the time in hours to the start date and get the time the order will be completed. Everything in my time frame hours.
For my first example I need the result to be 07:20 am of the next day because an order will start the first day at 06:20am and be able to complete in the first shift the next day.
Also need to consider my work days in the range.
Please be able to show a video to show a video to know you can do it...
ID do Projeto: #12877467
Sobre o projeto
Concedido a:
Hi I am an excel expert can give u this within few hours if u wish we can proceed further i can give u quick turnaround thanks looking forward positively
18 freelancers estão ofertando em média $347 nesse trabalho
Edit : I think the output in H3 should be 1/24/17 7:40 AM instead of 1/24/17 7:20 AM ? Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Ma Mais
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. HI SIR I CAN PROVIDE YOU VIDEO EXPLANATION FOR THE WORK AS WELL. Here is the reason. Why you s Mais
https://www.freelancer.com/u/sandroshubladze.html Hi, I am Excel expert and VBA programmer I will do what you need, if interested can show examples of my work Thanks & Regards
Good day. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
I've have an excellent knowledge of Excel, which I work with on a daily basis. I will provide you with an extremely accurate "if" function and at very quick turn around time.
Hi, I have completed the work as requested and found an error in your calculation. For a job start at 6.20 Am and end at 1.05 Am, for the example given, the job would end at 6.35 Am during the fist shift on the next Mais