8 Replies Latest reply on May 20, 2015 10:55 AM by gmaendel

    calculating time that a field has been TRUE.

    gmaendel

      Title

      calculating time that a field has been TRUE.

      Post

      I have a table with a dateTime, pumpOn GPM etc. etc.

      Lets say I have five Records...

      dateTime-------------pumpOn---GPM

      5/5/15 6:00:00 AM           0            800

      5/5/15 7:00:00 AM           1            800

      5/5/15 7:15:00 AM           1            800

      5/5/15 8:30:00 AM           1            800

      5/5/15 9:00:00 AM           0            800

       

      How would I calculate how long the pump has been on? 1.5Hrs

      I've tried searching google for anything on a calculation like this, but I'm not exactly sure what to search for.

      thanks in advance for any help.