PC Review


Reply
Thread Tools Rate Thread

Concatenate Doesn't Work for this

 
 
brad_pitstain@yahoo.com
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.

 
Reply With Quote
 
 
 
 
=?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.
>
>

 
Reply With Quote
 
 
 
 
=?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.
>
>

 
Reply With Quote
 
=?Utf-8?B?TWFyY2Vsbw==?=
Guest
Posts: n/a
 
      11th Sep 2006
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 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.
>
>

 
Reply With Quote
 
=?Utf-8?B?TWFyY2Vsbw==?=
Guest
Posts: n/a
 
      11th Sep 2006
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 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.
>
>

 
Reply With Quote
 
General Specific
Guest
Posts: n/a
 
      11th Sep 2006
There it is!

Thanks. How did I miss that simple solution.


Marcelo wrote:
> 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 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.
> >
> >


 
Reply With Quote
 
General Specific
Guest
Posts: n/a
 
      11th Sep 2006
There it is!

Thanks. How did I miss that simple solution.


Marcelo wrote:
> 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 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.
> >
> >


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenate and can grow do not work ken@kcookpcbiz.com Microsoft Access Reports 3 2nd Feb 2008 03:55 AM
Concatenate only if there is something to concatenate bhrosey via AccessMonster.com Microsoft Access Queries 5 18th Dec 2007 08:31 PM
Concatenate Doesn't Work for this brad_pitstain@yahoo.com Microsoft Excel Worksheet Functions 0 11th Sep 2006 07:51 PM
I know how to concatenate ,can one de-concatenate to split date? =?Utf-8?B?UVVJQ0sgQk9PS1MgUFJPQkxFTS0=?= Microsoft Excel New Users 1 26th Jul 2005 05:07 PM
Concatenate Function will not work Chuck W Microsoft Excel Misc 4 1st Feb 2005 12:41 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:07 PM.