| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate Doesn't Work for this
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenate Doesn't Work for this
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenate Doesn't Work for this
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatenate Doesn't Work for this
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
| My links no longer work . . . | Excel Discussion (Misc queries) | |||
| Work Rota - Do I need a formula? | Excel Discussion (Misc queries) | |||
| How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
Hybrid Mode
