Measurement Computing   Easy to Use | Easy to Integrate | Easy to Support catalog banner

DASYLab - Time does not show up correctly in Excel

Expand / Collapse
 

DASYLab - Time does not show up correctly in Excel


Question:


I save my DASYLab data into a DASYLab ASCII file. As recommended, I use <TAB> for the separator and I select "DATE+TIME" for the time stamp.

When I look at the data in Excel, it does not display the hours in the cell. The same data in a TEXT EDITOR, shows that the time is intact.
       

Answer:

Excel doesn't default to hh:mm:ss format when the time includes decimals. In the above case, the data was sampled at two samples/sec, creating a fractional second.

Change the Excel cell format from the default to a custom format

hh:mm:ss.0

Excel supports up to 3 decimals, using hh:mm:ss.000, as you can see below. Sample rates above 1000 samples/second will not display correctly in Excel.





Rate this Article:
Tags:

Add Your Comments


For comments email TechSupport@mccdaq.com.

Details
Article ID: 50319

Last Modified:7/29/2013 10:36:48 AM

Article has been viewed 4,067 times.

Options