LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a way to convert time from Labview into decimals on excel?

I want to have elapsed time shown on my excel spreadsheet as a decimal value.  I would like it to start at 0.00000 and go on from there.  Is this possible?  If so, how do I do that?
0 Kudos
Message 1 of 5
(2,942 Views)
If you could be more specific as to what type of signal it is. Are you using the elapsed time VI, is it a wavform, is it dynamic data. post a screen shot or the code. It is not a trivial thing to do but I need to know what type of data it is in order to you convert it to a string.



Joe.
"NOTHING IS EVER EASY"
Message 2 of 5
(2,933 Views)
I have attached my set-up.
0 Kudos
Message 3 of 5
(2,930 Views)
First off I would not use excel I would write the data to a text file. you could even write it to a LV measurement file. Second you have structures in your code that do not do anything. the case statement has a true wired to it so that the false case can never execeute. the While loop has a false constant wired into it that does not do any good. the ouput of the while loop only gives you the last piece of data that it received. you can enable indexing on the loop or use the array functions to code it up. The elapsed time should be given in the signal.



Joe.
"NOTHING IS EVER EASY"
Message 4 of 5
(2,924 Views)
You are absolutely right, I am only getting the last piece of data.  And just in case I haven't come off as a moron yet, how do I enable the indexing on the loop?  When I enable, where it lets me, it gives me errors to my corresponding inputs.  Thanks again. 
0 Kudos
Message 5 of 5
(2,910 Views)