# Concatenate Doesn't Work for this

Discussion in 'Microsoft Excel Worksheet Functions' started by brad_pitstain@yahoo.com, Sep 11, 2006.

1. ### Guest

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.

, Sep 11, 2006

2. ### GuestGuest

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...
--
HTH...

Jim Thomlinson

"" wrote:

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

Guest, Sep 11, 2006

3. ### GuestGuest

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...
--
HTH...

Jim Thomlinson

"" wrote:

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

Guest, Sep 11, 2006
4. ### GuestGuest

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

hth
--
regards from Brazil
Marcelo

"" escreveu:

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

Guest, Sep 11, 2006
5. ### GuestGuest

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

hth
--
regards from Brazil
Marcelo

"" escreveu:

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

Guest, Sep 11, 2006
6. ### General SpecificGuest

There it is!

Thanks. How did I miss that simple solution.

Marcelo wrote:
>
> just use a1+b1 (assuming 5/11/2006 is on a1 and 11:00 am in b1)
>
> hth
> --
> regards from Brazil
> Marcelo
>
>
>
> "" escreveu:
>
> > 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.
> >
> >

General Specific, Sep 11, 2006
7. ### General SpecificGuest

There it is!

Thanks. How did I miss that simple solution.

Marcelo wrote:
>
> just use a1+b1 (assuming 5/11/2006 is on a1 and 11:00 am in b1)
>
> hth
> --
> regards from Brazil
> Marcelo
>
>
>
> "" escreveu:
>
> > 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.
> >
> >

General Specific, Sep 11, 2006