3 Replies Latest reply on Jul 3, 2018 12:33 AM by Zhouyi Zhang

    Time series data clac

    Amir Rashidi

      Hi all,

      I hope this is an easy question.

      I am working on a time series data-set that shows the levels in a water tank. (i.e. 5.0 ML) in 15 minute time intervals. i.e. column A & B

      I need to calculate the tank outflow i.e. column C every hour like the below example.

         

      Date and TimePC VolumeTank outflow (ML/d)
      1/06/2017 0:0075%0.06=((B2-B6)/100)*24*5.0
      1/06/2017 0:1574%0.06
      1/06/2017 0:3072%0.048
      1/06/2017 0:4571%0.048
      1/06/2017 1:0070%0.048
      1/06/2017 1:1569%0.048
      1/06/2017 1:3068%0.06
      1/06/2017 1:4567%0.072
      1/06/2017 2:0066%0.072
      1/06/2017 2:1565%0.084
      1/06/2017 2:3063%0.096
      1/06/2017 2:4561%0.132