# Concatenate Doesn't Work for this

Guest
Posts: n/a

 11th Sep 2006
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.

=?Utf-8?B?SmltIFRob21saW5zb24=?=
Guest
Posts: n/a

 11th Sep 2006
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

"(E-Mail Removed)" 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.
>
>

=?Utf-8?B?SmltIFRob21saW5zb24=?=
Guest
Posts: n/a

 11th Sep 2006
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

"(E-Mail Removed)" 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.
>
>

=?Utf-8?B?TWFyY2Vsbw==?=
Guest
Posts: n/a

 11th Sep 2006

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

hth
--
regards from Brazil
Marcelo

"(E-Mail Removed)" 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.
>
>

=?Utf-8?B?TWFyY2Vsbw==?=
Guest
Posts: n/a

 11th Sep 2006

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

hth
--
regards from Brazil
Marcelo

"(E-Mail Removed)" 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
Guest
Posts: n/a

 11th Sep 2006
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
>
>
>
> "(E-Mail Removed)" 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
Guest
Posts: n/a

 11th Sep 2006
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
>
>
>
> "(E-Mail Removed)" 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.
> >
> >

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post ken@kcookpcbiz.com Microsoft Access Reports 3 2nd Feb 2008 03:55 AM bhrosey via AccessMonster.com Microsoft Access Queries 5 18th Dec 2007 08:31 PM brad_pitstain@yahoo.com Microsoft Excel Worksheet Functions 0 11th Sep 2006 07:51 PM =?Utf-8?B?UVVJQ0sgQk9PS1MgUFJPQkxFTS0=?= Microsoft Excel New Users 1 26th Jul 2005 05:07 PM Chuck W Microsoft Excel Misc 4 1st Feb 2005 12:41 AM

Features