format cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top