Hope to seek your kind assistance with this task I'm stuck with. In the table below, it shows the following columns. Here's a few things you may want to take note:
InstalledProductNumber have Onsite Service and Remote Service
CreatedDate for an InstalledProductNumber is always the same for Onsite or Remote
There could be multiple StartDateTime for Onsite Service and could be the same for Remote Service
The earliest StartDateTime of Onsite Service and Remote Service are used for comparison (in First Start Column)
This graph below shows the response time of Onsite Service and Remote Service.
This brings me to my question..
If the earliest StartDateTime of Remote Service starts later than the earliest Onsite Service, I would like to change the Remote Service Response time to 0, meaning I would only like to show the dark orange part with 03:12:09
But if the earliest StartDateTime of Onsite Service starts later than earliest Remote Service, I would like the graph to remain exactly the same as above.
Can somebody please advise me with some functions I could use? Much appreciated!
PS: i have attached the sample data in Excel for your reference.