Forum Discussion
Chuckie365
Feb 07, 2019Copper Contributor
difference in time in milliseconds for binary state logic
I am trying to take the data in a csv file and chart the logic states over time. Excel is not liking the time format. I can attach the csv file if needed.
I was thinking that i need to calculate the elapsed time for each state in order to plot the data so i know that it was 1 "True" for .425 seconds and then 0 "False" for 1.3 seconds and plotted for the entire duration.
If you have any helpful hits, i would appreciate it!
Thank you!
1 Reply
Sort By
- JKPieterseSilver ContributorSelect the column with dates, choose Data, Text to columns, delimited, check "Space" and click finish.