8 Replies Latest reply: May 25, 2015 1:02 PM by Marco Wedel RSS

    How to compare price at two different time intervals

      Hello experts

       

      I have couple of questions in regards to time/ranges.

       

      What I have is this:

       

      Column:

      Time

      07:00:00

      08:00:00

      09:00:00

      etc..

       

      Column:

      Price

      1400

      1410

      1390

      etc

       

      1) I need to know if the price at 07:00:00 was Higher then the price at 16:00:00?

      2) then I need to calculate the difference - by how many points

      3) and then I need to build time ranges and find an average price for each interval:

      range: 'morning' - time: 07-12

      range ' lunch' - time 12-13

      range 'evening' -  time 13-16

       

      Can you please help me with that. Thanks in advance for your help!