4 Replies Latest reply on Sep 16, 2013 1:00 AM by bart.groots

    difference between

    bart.groots

      Hi,

       

      I need to have the difference between 2 values, Every 2 hour.(energy gauge)

      I need to know how much Kh ervey 2 hour  the divice (collector) uses.

       

      20-1-2012 12:45:00789
      20-1-2012 13:00:00790
      20-1-2012 13:15:00790
      20-1-2012 13:30:00800
      20-1-2012 13:45:00810
      20-1-2012 14:00:00830
      20-1-2012 14:15:00855
      20-1-2012 14:30:00855
      20-1-2012 14:45:00860
      20-1-2012 15:00:00861
      20-1-2012 15:15:00861
      20-1-2012 15:30:00880
      20-1-2012 15:45:00891
      20-1-2012 16:00:0089969
      20-1-2012 16:15:00899
      20-1-2012 16:30:00900
      20-1-2012 16:45:00901
      20-1-2012 17:00:00920
      20-1-2012 17:15:00940
      20-1-2012 17:30:00941
      20-1-2012 17:45:00943
      20-1-2012 18:00:0094546
      20-1-2012 18:15:00950
      20-1-2012 18:30:00951
      20-1-2012 18:45:00955
      20-1-2012 19:00:00966
      20-1-2012 19:15:00970
      20-1-2012 19:30:00971
      20-1-2012 19:45:00978

                                                         ^    this  column i need.

      899 - 830 = 69 & 945 - 899 = 46

      can some one help me ?

       

      Greets