When using PI Datalink, I have been trying to use the =NOW()-TIME(0,0,30) formula for time. When I use this formula, all cells return "No Data" where PI Datalink should be pulling data in. When I change the formula to a typed-in date and time, the data comes in as it should. I even tried *-30s as the time and it works. However, I'd like the spreadsheet to display the date and time rather than the *-30s. Anyone know why this won't work?
Date and time physically typed into the cell and the data comes in
Date and time entered as the =NOW()-TIME(0,0,30) and the data will not come in.
Entered as the *-30s formula and the data comes in but the date/time are not displayed.