Difficulty merging a Date and Time
 

I am having trouble merging two cells together. One cell (Date formatted)
and another cell (Military Time formatted). I would like to bring these
together to represent one point in time.

How can I do this?

Difficulty merging a Date and Time
 

Just add them together and choose an appropriate format:

=A1+B1

Hope this helps.

Pete

On Apr 30, 5:06 pm, Adam wrote:
I am having trouble merging two cells together. One cell (Date formatted)
and another cell (Military Time formatted). I would like to bring these
together to represent one point in time.

How can I do this?

Difficulty merging a Date and Time
 

After you merge you havve to reformat tthe cell using your prefered format
for time.

"Adam" wrote:

I am having trouble merging two cells together. One cell (Date formatted)
and another cell (Military Time formatted). I would like to bring these
together to represent one point in time.

How can I do this?

Difficulty merging a Date and Time
 

I have tried to merge them by "concatenating" and I get a number value
result. I hav tried to format the number value result, but it does not work.
(i've copied/pasted values before i try formatting, and am getting no where)

How do you suggest merging the cells so that you can format them in a time?


"Joel" wrote:

After you merge you havve to reformat tthe cell using your prefered format
for time.

"Adam" wrote:

I am having trouble merging two cells together. One cell (Date formatted)
and another cell (Military Time formatted). I would like to bring these
together to represent one point in time.

How can I do this?

Difficulty merging a Date and Time
 

See Pete's reply ... just add them

=A1+B1

Result should format automatically to date/time



"Adam" wrote:

I have tried to merge them by "concatenating" and I get a number value
result. I hav tried to format the number value result, but it does not work.
(i've copied/pasted values before i try formatting, and am getting no where)

How do you suggest merging the cells so that you can format them in a time?


"Joel" wrote:

After you merge you havve to reformat tthe cell using your prefered format
for time.

"Adam" wrote:

I am having trouble merging two cells together. One cell (Date formatted)
and another cell (Military Time formatted). I would like to bring these
together to represent one point in time.

How can I do this?

Difficulty merging a Date and Time
 

Thank you all for your contribution. I did not have my downloaded "Time" data
formatted to excel Time format. Once I did that, the Addition approach worked
perfectly!


"Toppers" wrote:

See Pete's reply ... just add them

=A1+B1

Result should format automatically to date/time



"Adam" wrote:

I have tried to merge them by "concatenating" and I get a number value
result. I hav tried to format the number value result, but it does not work.
(i've copied/pasted values before i try formatting, and am getting no where)

How do you suggest merging the cells so that you can format them in a time?


"Joel" wrote:

After you merge you havve to reformat tthe cell using your prefered format
for time.

"Adam" wrote:

I am having trouble merging two cells together. One cell (Date formatted)
and another cell (Military Time formatted). I would like to bring these
together to represent one point in time.

How can I do this?