LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to read time stamps from a spreadsheet and calculate the difference between consecutive time stamps?

Hi,
 
I am new to Labview. This question might be a joke to some of you here, but any help would be greatly appreciated. I have a spreadsheet with time stamps and power outputs from a generator. I am supposed to calculate the difference between consecutive time stamps, which will act as a delay for the next power output update that needs to be sent. For example, lets say that I have to following data:
 
Time Stamp                    Power Output
11:00:00 AM                       3kW
11:00:02 AM                       2.9kW
11:00:04 AM                       3.2kW
11:00:06 AM                       3.1kW
 
The above data doesn't make any sense, but it is just for the purpose of this question.
 
So, I have to read 11:00:00 AM and 3kW initially - 3kW is the initial request that is sent. Then
0 Kudos
Message 1 of 6
(3,782 Views)
 
------- LabVIEW 2009, So Easy, Even a Therapist Can Do It -------
0 Kudos
Message 2 of 6
(3,762 Views)
This is a demo of reading the data.   You can use it as a reference.  It only read the time disregard of AM.
------- LabVIEW 2009, So Easy, Even a Therapist Can Do It -------
Download All
0 Kudos
Message 3 of 6
(3,761 Views)
Your need to do Differeciation . and use differenciator fuction to do the same
will help a lot
 
Haider
0 Kudos
Message 4 of 6
(3,714 Views)


Haider Abbas wrote:
Your need to do Differeciation . and use differenciator fuction to do the same
will help a lot
 
Haider



Okay, that must be a new word.  What is a "differeciation" or "differenciator" function?Smiley Very Happy
0 Kudos
Message 5 of 6
(3,705 Views)

Hi,

Thanks for the example, Weiyuan! Does this help you with your program, HHH?

Amanda Howard
Americas Services and Support Recruiting Manager
National Instruments
0 Kudos
Message 6 of 6
(3,686 Views)