Time Conversions

[Spencer]

I have a data file, the first column is the time (HH:MM:SS AM/PM) that
the data is taken at. The subsequent columns contain numerical data. I
read the file using the "Read Lines from Spreadsheet" subvi. I am
writing a VI that reads the file and allows you to choose which column
of data you want to view in an XY graph. I change the spreadsheet
spring to an array, and I can change the numerical data to floats. I'm
having trouble processing the time stamp. This would seem to be a
rather common problem, has anyone come up with a good way to convert
time data to something that I can graph on an XY graph. Any ideas?

Spencer
spencerwa@hotmail.com


Sent via Deja.com http://www.deja.com/
Before you buy.

[jack Schitt]

I ran into a problem doing this a few years ago. you may wish to read this
and see if my solution will help you out.

The problem was that when data logging and using the Date/Time vi, the date
and time functions worked well for the real time display, but the logged
data file had messed up time data and wouldn't graph properly. After much
probing I found that the "number of seconds past 1904" function was
generating a number that was too large for the spreadsheet file .VIs. I
modified the VIs to accept DBL numbers and all was fine from then on.

Could this be what is buggering up your graph?

Best Regards,
Jack


Spencer wrote in message <8hrngj$jim$1@nnrp1.deja.com>...
>I have a data file, the first column is the time (HH:MM:SS AM/PM) that
>the data is taken at.
The subsequent columns contain numerical data. I
>read the file using the "Read Lines from Spreadsheet" subvi. I am
>writing a VI that reads the file and allows you to choose which column
>of data you want to view in an XY graph. I change the spreadsheet
>spring to an array, and I can change the numerical data to floats. I'm
>having trouble processing the time stamp. This would seem to be a
>rather common problem, has anyone come up with a good way to convert
>time data to something that I can graph on an XY graph. Any ideas?
>
>Spencer
>spencerwa@hotmail.com
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.