setting time adding seconds

[krispiekream]

hi guys, i am stuck and i need help with this one and its an emergency. i dont have 1 more week to test because i needed to get the data ASAP. i have this test that i did for 1 whole week, but i screwed up on one thing. I didn't have the seconds on my get date/time.  My coworker needs the second in my test in order to get the results for his test.

can someone please help me with this. 

 

on column B, this there a way to generate seconds with excel or labview in a way that it would not loose the HR/MINs or its order. 

please someone help me. 

Message Edited by krispiekream on 10-21-2008 06:14 PM

[tbd · Accepted solution]

Hi krispiekream,

      I hate to be there bearer of bad news, but it looks like the spreadsheet was written as csv  - and column B was written as it appears in your post.  In other words, there is no 'seconds' detail to be displayed.  If a LabVIEW program is creating the csv data, that program can be (must be) modified to include seconds detail!

Luck/Cheers.

Message Edited by tbd on 10-21-2008 08:27 PM

[AHK]

Hi krispiekream,

 You just make the want seconds True in the get time and date VI it will gnerate seconds for you. 

Regards

Akshath

(appreciate answer by giving KUDOS)

Hit the stars.........As sky is not the limit. 

[krispiekream]

yeah. i know that i can re-run the test after modifying the code, but i dont have 1 week to re-run the test. i kinda need it right away.

i wasted a whole week of good data.  i know that excel have ways to add seconds into time already exist. bu i am hoping that labview does too. 

"Sky is not the limit"..hehehe. like my boss would say. "If I can think of you, Labview can do it"

[krispiekream]

excel can do it by using this "formula will generate random seconds between 1 and 59 to add to your times, so if you put this in B1 and copy down, then copy column B and paste values into column D, then sort column D accending. Format cells to hh:mm:ss PM

=A1+RANDBETWEEN(1,59)/(3600*24) __________________"

 

Message Edited by krispiekream on 10-22-2008 08:47 AM

[Karunya_R]

Hi Krispekreme,

I am going to agree with tbd. Unfortunately, there is no possibility to do this running the LabVIEW program again.

Sorry 

[Cory_K]

If the data was collected over some regular increment you could do this.

Read in the second column of data.

Then, if there are 6 data points at 3:30, add 10 seconds to each time:

3:30:00

3:30:10

3:30:20

3:30:30

 .....

then re-write the file with the new column

That VI should not be that difficult to write, just a simple for loop that adds a value for seconds. 

[krispiekream]

alright, i give up. i am just going to collect the data again. now with the seconds in them.

thanks for everyone help.