# Combining two columns

#### marg

##### New Member
I have two columns A being the date B being time (24hr). Is there any way of combining the two columns together.
I am trying to calculate the elapsed time.
Previously I have physically typed the time into the date cell, this takes a long time as I have up to 1000 entries.

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### poorwallace

##### Active Member
something like "=A1&B1" or if you want a space between the two =A1&" " &B1 ...

is that what you're getting at?

#### jindon

##### MrExcel MVP
Hi

have you tried in cell C1

=a1+b1

#### marg

##### New Member
Thank you both very much for the prompt reply. The first answer game me just a string of numbers. The second one works a treat. You have saved me hours of work.
Sometimes you feel a bit of a dummie when such a simple formula works.
I have been learning excel on the fly - never had any tuition on it and I am compiling some data for a hospital emergency department as a volunteer.
Again THANKYOU

#### Client

##### New Member
Thanks,

in Cell: A1
1/1/2006

in Cell: B1
13:30:00

in Cell: C1

=A1+B1 >Result: 01/01/2006 13:30
(Did work fine and formated)

But when I tried:
A1&" "&B1 >Result: 38718 0.5625
When I apply "Format Cell dd/mm/yyyy h:mm"
nothing Changed!

Thanks again.

#### jindon

##### MrExcel MVP
You need to change cell format like

m/d/yyyy h:mm

adjust the space between date and time

Replies
5
Views
101
Replies
3
Views
99
Replies
1
Views
62
Replies
8
Views
169
Replies
0
Views
84