|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 11th, 2006, 07:51 PM
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
September 11th, 2006, 08:02 PM
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
September 11th, 2006, 08:05 PM
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
September 11th, 2006, 08:23 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
