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
    #1
    1. Advertisements

  2. Guest 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...
    --
    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
    #2
    1. Advertisements

  3. Guest 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...
    --
    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
  4. Guest 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



    "" 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
    #4
  5. Guest 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



    "" 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
  6. 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
    >
    >
    >
    > "" 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
    #6
  7. 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
    >
    >
    >
    > "" 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
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Embed command button from the control toolbox doesnt work

    Guest, Nov 16, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    175
    Guest
    Nov 16, 2004
  2. Guest

    Embed command button from the control toolbox doesnt work

    Guest, Nov 16, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    178
    Myrna Larson
    Nov 16, 2004
  3. Guest

    Formula doesnt work

    Guest, Feb 24, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    157
    Guest
    Feb 24, 2005
  4. Concatenate Doesn't Work for this

    , Sep 11, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    178
  5. TracySLPS

    concatenate won't work

    TracySLPS, Apr 22, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    6
    Views:
    682
    TracySLPS
    Apr 22, 2009
Loading...

Share This Page