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?

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

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?

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

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

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