Excel Overlap Formula
$10-30 USD
Paid on delivery
I need (IN EXCEL) to know when two times overlap.
Please see image for visual example. Below is written example.
1) You will notice that Sales Person 3 and Sales Person 4 both worked a shift.
2) There was overlap from 08:03 thru 08:21
3) There was no overlap from 8:00 to 08:03
4) There was no overlap from 8:21 to 08:22
I need to know (REQUIRED)
1) OVERLAP
I would like to know (ICING ON THE CAKE)
2) There was overlap from 08:03 thru 08:21
3) There was no overlap from 8:00 to 08:03
4) There was no overlap from 8:21 to 08:22
I need to be able to see the formula detail (for example =sumproduct, etc.) so that if I copy or mimic for new possible tests
Project ID: #17397308
About the project
Awarded to:
I can provide you with a customized function to calculate overlaps as you specified in the picture or a formula using in built excel functions whatever you would like. Relevant Skills and Experience I am an advanced E More
23 freelancers are bidding on average $23 for this job
I can do it for you quickly and exactly by VBA Relevant Skills and Experience I have finished great than 100 Excel project in thí site Proposed Milestones $50 USD - Finished
Hi, I am an expert in excel and can create this formula for free. Relevant Skills and Experience 7 years experience in excel. Proposed Milestones $30 USD - . If you are interested contact me in chat. thanks
Hello, I can write this formula for you. Future support is includet in my offer. Would be happy to do this work. Best regards, Michael
Hi there, I have gone through the image shared and the requirements carefully and i create a formula to identify the overlap and no overlap in timing. Relevant Skills and Experience I am an excel expert with more tha More
Hello dear, I am a M.Sc. engineer. I am expert in Excel so I can help you for sure in your task. Thanks
Excel Overlap Formula Relevant Skills and Experience Data Entry, Data Processing, Excel, Mathematics, Visual Basic Proposed Milestones $25 USD - 0 I read your project description…….........and we are very exited to More
hi Relevant Skills and Experience graphics designer Proposed Milestones $16 USD - create milestone
Hi, I am interested for the job you mentioned. Thanks and best regards, Lucky Relevant Skills and Experience I have work experience above 3 years. Proposed Milestones $15 USD - Milestone
I have proficiency in using excel at advanced levels and this task will prove my worth. I will request for payment after successful implementation and confirmation of formula. My work is my vow. Relevant Skills and More
Hello, I'am experienced with Excel, I use VBA, C#, R and anything related to Excel. I do have an excellent education background and a 8y+ experience in quantitative financial research (front office) creating models, te More