NickT Posted October 15, 2019 Report Share Posted October 15, 2019 What is the most efficient way to store date and time in an excel table so that it is easily view able in Excel? I converted it to a string, but the strings take up too much PLC memory. Excel can't natively interpret Unix time, so that won't work either. Is there something else Excel can interpret that I can store it as? Quote Link to comment Share on other sites More sharing options...
Gabriel Franco Posted October 15, 2019 Report Share Posted October 15, 2019 Yoy can save it as UTC (double word, seconds from 01/01/1900) and then in Excel convert it to date/time format. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.