Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I trying to locate overlapping times (as shown below)
Engineers enter Job start and finish times. But often these times overlap by enginner
I have identified these as follows
if(Count(total <FSR_Start_Date, FSREngineer> FSR_Start_Date & FSREngineer)>1
,Count ( total <FSR_Start_Date , FSREngineer> FSR_Start_Date & FSREngineer))
and
(Count (total <FSR_Complete_Date , FSREngineer> FSR_Complete_Date & FSREngineer)>1
,Count ( total <FSR_Complete_Date ,
FSREngineer> FSR_Complete_Date & FSREngineer))
This works well if the start or finish time is the same. But not in the example shown below
I could use interval match (in some way). But is there another simple way to identify
overlapping times by engineers by using an expression (rather than a script
change)
(or includng in script without using interval match
Thanks for any assistance
Engineer | FSR Start | Complete |
GB156 | 20/05/2014 10:00 | 20/05/2014 10:40 |
GB156 | 20/05/2014 12:30 | 20/05/2014 13:15 |
GB156 | 20/05/2014 13:30 | 20/05/2014 13:50 |
GB156 | 20/05/2014 13:31 | 20/05/2014 14:40 |
GB156 | 20/05/2014 13:51 | 20/05/2014 14:15 |
GB156 | 20/05/2014 14:55 | 20/05/2014 15:15 |
GB156 | 20/05/2014 15:15 | 20/05/2014 15:30 |
Maybe something like this:
Thanks Dariusz
I will work on this tomorrow.