AnsweredAssumed Answered

Count hours

Question asked by SandyHaaf on Dec 20, 2012
Latest reply on Dec 20, 2012 by philmodjunk

Title

Count hours

Post


     So I have this database that will have millions of entries.  For each wind turbine(there will be many), there will be an entry about every couple of seconds.  Each entry is timestamped.

      

     I need to create a report that will count the number of hours that a event happens.  For example, there could be a status field that will normally be 'on' but when something happens it will switch to 'off' .  What I want to do is be able to count the hours that it was operating normally.  Then, I'd like to count the hours that it was 'off' or 'being serviced'

      

     How do I go about this?  Any guidance would be appreciated.

      

     Thanks,

     Sandy

Outcomes