How do I add 1 minute down a Cilumn in Excel pulling in Pi Acrhival Data. I know the formula for pulling data in

=PIArcVal("00-GTG-DATA1/GTG_VOLTS.CV","1-jul-19 09:00",0,"AWS01","auto") How do I get that 0900 to increment by 1 minute down the column, for a total of 300 minutes ?

Hi Mike,

The PIArcVal is a single value function. If you would like to get multiple values for 5 hours time frame, then I suggest you use 'Sampled Data' function from the PI DataLink's ribbon menu.

Using the UI is important as we may offer up to 3 different functions to do a similar job depending on the options.

In your case, the UI let me use PISampDat as below:

=PISampDat("00-GTG-DATA1/GTG_VOLTS.CV","1-jul-2019 09:00","+300m","1m",1,"AWS")