| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to concatenate date and time?
If there is a date in one column and a time in another is there a way to make
the third column DateTime based on a conatenation of the other two columns? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to concatenate date and time?
On Tue, 19 Sep 2006 09:16:02 -0700, chazparks
wrote: If there is a date in one column and a time in another is there a way to make the third column DateTime based on a conatenation of the other two columns? =A1+B1 Format to taste --ron |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to concatenate date and time?
When I try this I get #VALUE! instead of a datatime.
A1 = 04/03/78 B1 = 12:00pm "Ron Rosenfeld" wrote: On Tue, 19 Sep 2006 09:16:02 -0700, chazparks wrote: If there is a date in one column and a time in another is there a way to make the third column DateTime based on a conatenation of the other two columns? =A1+B1 Format to taste --ron |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to concatenate date and time?
I would guess that your time is not a *true* XL time.
If you really need the PM and/or AM, you *must* leave a space between the numbers and letters when making your entry. Type 12:00 p OR 12:00 a And you'll get an XL recognized value. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "chazparks" wrote in message ... When I try this I get #VALUE! instead of a datatime. A1 = 04/03/78 B1 = 12:00pm "Ron Rosenfeld" wrote: On Tue, 19 Sep 2006 09:16:02 -0700, chazparks wrote: If there is a date in one column and a time in another is there a way to make the third column DateTime based on a conatenation of the other two columns? =A1+B1 Format to taste --ron |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to concatenate date and time?
On Tue, 19 Sep 2006 14:01:02 -0700, chazparks
wrote: When I try this I get #VALUE! instead of a datatime. A1 = 04/03/78 B1 = 12:00pm You are entering the values incorrectly. 1. No <equal sign 2. There must be a space before the "pm" A1: 04/03/78 B1: 12:00 P (or 12:00 pm) --ron |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to concatenate date and time?
If you have the Date in A1 and the Time in B1 and you want the DateTime to be
in C1. Put the following formula in C1. =A1+B1 "chazparks" wrote: If there is a date in one column and a time in another is there a way to make the third column DateTime based on a conatenation of the other two columns? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Hybrid Mode
