Current Position:Home > Calculate time difference in Labview from excel file

Calculate time difference in Labview from excel file

Update:10-11Source: network consolidation
Advertisement
I am reading in values from a excel files, the file contains date and time data in one cell, then either an On or Off value in the cell next to it. I would like to find the time difference between the on and the off cycles. The VI I have so far brings in the Excel file but I don't know how to subtract the dates. Any help would be appreciated. I have attached the vi and hopefully I can attach and example excel file.
Attachments:
Hobo Import.vi ‏156 KB

The Best Answer

Advertisement
Hi Bryan!
I made a small VI (in LabVIEW 7.1) that converts to strings (of your format) to timestamp datatype and then subtracts them resulting in a difference measured in seconds. There might be a more optimal way to do this in your application, but I thought I'd at least try to contribute. Also, notice that there is a Y3K bug in there :-)
Hope this helps!
Travis H.
National Instruments
Travis H.
LabVIEW R&D
National Instruments
Attachments:
FormattoTimeStamp.vi ‏38 KB
  • Calculate time difference in Labview from excel file Update:10-11

    I am reading in values from a excel files, the file contains date and time data in one cell, then either an On or Off value in the cell next to it. I would like to find the time difference between the on and the off cycles. The VI I have so far bring

  • Labview into excel file Update:11-30

    hello...i'm using labview 8.5 for my final year project..can i convert the graph in the labview into excel file by using this labview version? please...help me....ahaksss Solved! Go to Solution.If you just want the data, then this may be an option (I

  • How i can insert symbol of infinity or resistance by labview into excel file Update:11-30

    Hi. i need insert infinity synbol into report excel file. how can i do this easly, maybe you have ready function for this target. Solved! Go to Solution. Attachments: 26.08.jpg ‏4 KB 26.081.jpg ‏2 KBIf you don't want to get into EXCEL class & its pro

  • Calculate the sum of values in excel file and import it to SQL table using SSIS Update:11-30

    Hi, Can some one help me how to do auto sum of columns in SQL table  using SSIS in SQL table the HRA , PF and Basic should not come, Only it should appear in basic pay as the sum of HRA , PF and Basic...RSingh, Thanks for the use of derived column. I

  • How to make my waveform from excel file perodic in labview graph Update:10-11

    Hi guys, Previously I've made a vi which integrates the excel file, to plot the graph values in labview using the values in the excel file to give the me a better flexibility to decide what waveform i want it to be. Can i know how to actually make th

  • How can i display a excel file generated by labview? Update:10-11

    hello, I'm looking for an exemple to display (open) a .xls file generated by labview after simulation but without use  the tookit report generation. somebody knows how could I do this? Any suggestions? Thanks, longar p.s: i use labview 8.6  Solved! G

  • Can I open a excel file from labview Update:10-11

    I have a program who write temperature in a excel file and i want to open this file from labview .This depends slightly on the amount of data you have stored within Excel. You can use the "Labview Functions>>FileIO>>Read from Spreadsheet

  • Creating Excel file in Labview Update:10-11

    I am trying to create a new Excel file, read it then close it using Active X programaticaly. Any help on this will be appreciated. Regards, AymanAyman Take a look at this thread http://forums.ni.com/ni/board/message?board.id=BreakPoint&message.id=239

  • How can I read fast 50 MB Excel file in LabVIEW Update:10-11

    Hi, I have created a datalog file containing string i/p and having extension ".exl". File size is around 50 MB. When I read this file using LabVIEW, it takes 1/2 hour to display data in Array. How can I minimize this read time in LabVIEW. Or is

  • Why does TDM Importer start up when I open an Excel file in LabVIEW, and how can I stop it? Update:11-30

    I have a new application using LabVIEW 2012 SP1.  I open an Excel file using the Report Generation toolkit and when I do so, a small TDM Importer window pops up on top of the Excel file.   How can I prevent this?Hi Steve, The TDM Importer pops up bec