Difficulty merging a Date and Time

[Guest]

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?

 

[Pete_UK]

Just add them together and choose an appropriate format:

=A1+B1

Hope this helps.

Pete

 

[Guest]

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

 

[Guest]

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?

 

[Guest]

See Pete's reply ... just add them

=A1+B1

Result should format automatically to date/time

 

[Guest]

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!