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

### 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

### 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

### 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 I have

### 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 I have to

### 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 I

### 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.

### 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

### 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

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

This is a demo of reading the data.   You can use it as a reference.  It only read the time disregard of AM.

test.xls:
http://www.yqcomputer.com/

http://www.yqcomputer.com/

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

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

Haider

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

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?:smileyvery-happy:

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

Hello
you can simple subtract one time from the other one and so you get the difference. -> Example
Mike

Unbenannt 2.vi:
http://www.yqcomputer.com/