Combining two columns

marg

New Member
Joined
Apr 20, 2005
Messages
9
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.
 

Some videos you may like

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
Joined
Mar 8, 2005
Messages
365
something like "=A1&B1" or if you want a space between the two =A1&" " &B1 ...

is that what you're getting at?
 

marg

New Member
Joined
Apr 20, 2005
Messages
9
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. :biggrin:
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
Joined
Dec 10, 2005
Messages
9
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
Joined
Aug 21, 2004
Messages
16,995
You need to change cell format like

m/d/yyyy h:mm

adjust the space between date and time
 

Watch MrExcel Video

Forum statistics

Threads
1,118,388
Messages
5,571,847
Members
412,420
Latest member
grace_abar
Top