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

    How to retain subscripting/superscripting with CONCATENATE

    Kenneth Dahl, Jun 29, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    706
    J.E. McGimpsey
    Jun 29, 2003
  2. Bill Groenewoud

    concatenate function (Excel 97)

    Bill Groenewoud, Jul 1, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    900
  3. Brendon

    Concatenate Text to create Formula

    Brendon, Jul 8, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    879
  4. Lance

    Can you nest a CONCATENATE within a VLOOKUP

    Lance, Jul 17, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    1,072
  5. anne

    CONCATENATE

    anne, Jul 17, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    255
    Tim Otero
    Jul 17, 2003
  6. anne

    Concatenate Function

    anne, Jul 17, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    256
  7. Concatenate Doesn't Work for this

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

    concatenate won't work

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