Home > Community > General > importing time format from Excel > Reply To: importing time format from Excel

#12591
Dermot CraddenDermot Cradden
Participant

Every time i try to import a column of time formated data from Excel (embedded or not)it shows up as floating point and i cannot reformat it back properly.
Even creating a dataset with the time span format and doing a copy paste does not help.

Also, When I select a whole column in excel and copy, then paste into an open dataset i only copy the first value.

What am i doing wrong?