Is there a way to concatenate date and time?

[Guest]

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?

 

[Ron Rosenfeld]

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

 

[Guest]

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

 

[Guest]

When I try this I get #VALUE! instead of a datatime.

A1 = 04/03/78
B1 = 12:00pm

 

[RagDyer]

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.

 

[Ron Rosenfeld]

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