Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
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:
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.