Concatenate Doesn't Work for this

B

brad_pitstain

On a labor time spreadsheet, The date is in one cell and the time is
shown in successive cells for each record.

I need to be able to merge the date (5/11/2006) and the time (11:00 am)
in order to get (5/11/2006 11:00 am).

Concatenate isn't helping.
 
G

Guest

Try just adding the two cells together...

=A1 + B1

Assuming that you have an excel date in the one cell and an excle time in
the other this should work...
 
G

Guest

Try just adding the two cells together...

=A1 + B1

Assuming that you have an excel date in the one cell and an excle time in
the other this should work...
 
G

Guest

Hi Brad,

just use a1+b1 (assuming 5/11/2006 is on a1 and 11:00 am in b1)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"(e-mail address removed)" escreveu:
 
G

Guest

Hi Brad,

just use a1+b1 (assuming 5/11/2006 is on a1 and 11:00 am in b1)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"(e-mail address removed)" escreveu:
 

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

match formula needed 2
Concatenate function 2
Dynamic CONCATENATE and LOOKUP 1
using a time format in a count function 1
Need formulas to pull date and time from 1 cell to 2 6
Help with Concatenation 8
HELP! I need to make an IF Statement comparing date/time fields.. 2
IF Function and Concatenation 8

Top