AnsweredAssumed Answered

calculating time that a field has been TRUE.

Question asked by gmaendel on May 16, 2015
Latest reply on May 20, 2015 by 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.

Outcomes