Excel Overlap Formula

Completed Posted 5 years ago Paid on delivery
Completed 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

Data Entry Data Processing Excel Mathematics Visual Basic

Project ID: #17397308

About the project

23 proposals Remote project Active 5 years ago

Awarded to:

sourabhg98

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

$14 USD in 1 day
(149 Reviews)
6.1

23 freelancers are bidding on average $23 for this job

zebracaro

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

$50 USD in 1 day
(129 Reviews)
7.1
DeepSyaal

Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements? Relevant Skills and Experience Excel Proposed Milestones $20 USD More

$20 USD in 1 day
(301 Reviews)
6.7
vlayausa

Hello, I would suggest making a custom Excel function with VBA for this purpose. It would call a code that could check if there was overlap and also add period of overlapping in separate cell. Relevant Skills and Exp More

$25 USD in 1 day
(149 Reviews)
5.9
aimefx

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

$30 USD in 1 day
(91 Reviews)
6.1
Phooka18

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

$25 USD in 3 days
(14 Reviews)
4.5
caprateekr

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

$30 USD in 1 day
(17 Reviews)
4.1
androaiad

Hello dear, I am a M.Sc. engineer. I am expert in Excel so I can help you for sure in your task. Thanks

$10 USD in 1 day
(12 Reviews)
4.2
lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I can manage the formulation you need for this. Relevant Skills and Experience I have a large experience working with advanced Exc More

$20 USD in 1 day
(15 Reviews)
3.7
Joni058

let me do it

$20 USD in 1 day
(6 Reviews)
3.0
leoclg

Hi, I am entry level freelancer Relevant Skills and Experience fully expert in MS Office (Full), Google Spreadsheet and other related programs. Proposed Milestones $20 USD - I can assure you that I will be able to su More

$20 USD in 2 days
(3 Reviews)
1.2
anasalnasan10

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

$25 USD in 1 day
(0 Reviews)
0.0
firozaakter1p

hi Relevant Skills and Experience graphics designer Proposed Milestones $16 USD - create milestone

$16 USD in 1 day
(0 Reviews)
0.0
Lucky773

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

$15 USD in 1 day
(0 Reviews)
0.0
onderiorina

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

$23 USD in 1 day
(0 Reviews)
0.0
HighlyPolyvalent

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

$20 USD in 1 day
(0 Reviews)
0.0
sachint9521

work fast

$25 USD in 5 days
(0 Reviews)
0.0