Advanced Search

Question: Importing data from Excel with correct formatting

Question:Importing data from Excel with correct formatting

whatever 25 Maple
excel import
February 13 2011
0

Hello,

I am trying to import some data into Maple from an Excel sheet that contains three columns.

Column 1 is simply an index number for the measurement running from 1 to 3185.

Column 2 is the time of the measurement ( e.g 10:23:44 ) with Excel formatting as "time".

Column 3 is the measured CO2 concentration logged at the psecific time.

My problem is that when I import the data into Maple using the ExcelTools,Import or simply the Import Data Asssistant, the formatting of the times in column 2 lose their formatting and look like this :40583.250555555554, when they should look like this 10:23:44.

Thanks for any input
Please Wait...