Time Stamp read problem with Spreadsheet String To Array

[Nishant]

Hiii,

      David I want same thing as Senpre wants, that reading the data from the file and displaying it on the XY graph, and i have the .xls file with the text format(tab delimited), but it is whoeing some error and not dislaying anything in the Date/Time Record, can you please explain me what should be done for this, i am sending you example xls file here. plssss do it for me, i have tried so many things for this but not successively atleast single.

Thanks in Advance,

Nishant

[DavidJCrawford]

Hi Nishant

Oops no file with your post.

David

[Nishant]

Sorry,

       Actually i was trying to edit the message but it wsn't happened bcoz of our server failure, now i am sending you the excel file and error both. can you pls show the data on graph???

Sorry and Thanks,

Nishant

[DavidJCrawford]

Nishant

What I did for Senper won't work for you as your date/time formats are completely different.

In your case you can convert like this

Read up on how scan from string works and look at some of the examples that use it. Tell me what labview are using and I will attach the file if you want it.

David

Message Edited by David Crawford on 02-03-2006 03:48 AM

[Nishant]

Hiii, David

      Can you please post me the vi?? i am not able to get somethings from this jpg. plssss

Thanks,

Nishant

[DavidJCrawford]

What version of labview?

Is version 8 OK?

[Nishant]

Ya, it will be OK, but 7.1 is more prefferable, if u r posting it on the LV8, just write down with it, else if possible send it on the 7.1 , coz for the 8 i ve to go to another PC.

Thanks,

Nishant

[DavidJCrawford]

Version in 7.1 attached

[Nishant]

Hiii,

       David, this is waht i want man, but why the time is showing 6:45:57 AM instead of 1:15:57? i think the conversion has been dodne in the 4557 seconds, then after how can i calculte it? coz no to time stamp converts it to the 6:45:57 AM.

Thanks,

Nishant

[DavidJCrawford]

Its a timezone thing