Forum Discussion

Sab's avatar
Sab
Icon for Helper V rankHelper 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
Icon for Helper V rankHelper V
3 years ago

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

 

 

    • Sab's avatar
      Sab
      Icon for Helper V rankHelper 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)