Hi sorry for the inconvenience, I attached dummy data excel file. I take 1st 300 observation Here I've 30 station pressure values at the same timestamp. (Seq 1 to 30 takes as a Station Name sequentially). Now take 2nd Observation of time 01Jun2010 0:01:00 and its 1st station is "first" and its corresponding pressure value is P1=32. Now see the time variable, Take Sum of that time till 60 or more than 60, then see the corresponding row station is 6. So take that station's next Hour's value as a P2 (Here in our case 01Jun2010 1:01:00 seq no 6 that is station 6 Pressure value P2=40) So for the 2nd Station pressure value is P1=32 and P2=40. DateTime SEQ P01 Travel_Time_Minute P02 01Jun2010 0:01:00 01 37 01Jun2010 0:01:00 02 32 13.37158349 40 This Scenario is like this when I stand at 1st station pressure value as p1 and I want to know after 60 min next station pressure value is P2.
... View more