AnsweredAssumed Answered

Datalink Timestamp in Excel

Question asked by SC_HO on May 16, 2019
Latest reply on May 16, 2019 by Eugene Lee

I need to create a dynamic column for people to enter a specific time of desired PI data in Excel.  How to make a timestamp reference stored at different cells? e.g. something like:  =PITimeDat(C11,"E2+E3","interpolated")

 

C11 = PI tag

E2 = Today's date i.e. Today()

E3 = time in hh:mm e.g. 00:00  = this is input manually by users

Outcomes