How do I merge 2 columns of numerical data?

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

Guest

In column A I have the time in hh:mm:ss (13:36:05) format, in column B I have
the millisecond value (0.256). I have 3000 rows of data in this format and I
want to combine the columns into one column of format hh:mm:ss.000
(13:36:05.256)

how do I do this? I've tried "concatenate" but I think this only works with
text (does it?)

Can anyone help me?

Thanks in advance, this is proving a real head-ache for me.

Callum.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I delete merged cells in Excel without deleting the final d 5
Columns formatting 2
How can I get Pivot Tables to recognise time formatted data 1
very urgent : to write the value of next column of the same row 2
i need to format a column as microseconds ? how do i do this 1
Calculating elapsed time 2
Merge 2 columns 4
how do i merge the datas in 2 columns 3

Back
Top