05-31-2017 09:05 AM
I wrote this code to take the Log Time from a CSV file and it utilizes arrays but the AM/PM from the excel file does not get incorporated to the Log Time after Labview retrieves the numbers. Can someone help? The results only return for example 11:30:45
05-31-2017 09:22 AM
It will be easier with your CSV file.
05-31-2017 09:23 AM - edited 05-31-2017 09:23 AM
Here you go. I cannot format the csv file any differently
05-31-2017 09:40 AM
The "Log Time" is in 24-hour format. There is no AM/PM to get.
05-31-2017 09:49 AM - edited 05-31-2017 09:50 AM
Your .CSV file Log Time is in 24 hour format
Open your .CSV file
Highlight the Log Time column
Right click and select "Format Cells" from the popup menu
Then select Time
Accept or change to the "default" AM/PM time format at the top of the format list
save your .CSV file
Run your program, it works.
05-31-2017 10:05 AM
I think I am going to keep it as a 24 hour format. By any chance do you know how to convert a time string into a number in TestStand in order to compare two times using a If statement?