Is there a way to concatenate date and time?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...


=A1+B1

Format to taste
--ron
 
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
 
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.
 
When I try this I get #VALUE! instead of a datatime.

A1 = 04/03/78
B1 = 12:00pm
Click to expand...

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
 
Back
Top