Forum Discussion

Sab's avatar
Sab
Helper V
3 years ago

Duration between thread times

Hello   I have a table with some duration data (see the table below). I need to calculate the duration with the following conditions:   1. If the time between threads in different tables is overl...
Need Help
Sab's avatar
Sab
Helper V
3 years ago

So for the given dataset, the duration should be: (2 -1) + (4-3) + (6-5)

 

 

  • Sab's avatar
    Sab
    Helper V
    3 years ago

    Hey Ryan, thanks for taking the time to look at it. Please see the screenshot below. It is doing some extra calculations that are not needed. 

     

    We should get only three rows (one for each color)