format cells-copied data from the txt file

[Eric]

i copied data from the txt file into excel, i got 2 colunms, one was
-000:00:00( it is negctive) and other one was 0.1, 0.2.....999.9(from first
row to last row), these two colunms were the time mark, the first one is the
hours, minutes and second, the second colunm is the mSecond, i'd like to
combine them into one colunm, but i cannot, excel didnot identify the first
colunm is time. anyone can help me? thanks

[Lotus123]

Not sure exactly what the data looks like, but you can manipulate all of your data with LEFT(), RIGHT(), MID() and CONCATENATE() to get it into hours, minutes, and seconds (if thta is even necessary). Then use the TIME() function to put it all together. Probably not that complicated of an issue, but that is everything you would need in a worse-case scenario.