Concatenate Date & Time

[BrianM]

What is the simplest way to concatenate Date A1 = 04/22/04 with B1 = 18:09:50 so that the result is 04/22/04 18:09:50


Thanks,
Brian

 

[DRJ]

=A1 + B1

Format as mm/dd/yy h:mm:ss

 

[Smitty]

=TEXT(A1,"mm/dd/yy")&" " &TEXT(B1,"hh:mm:ss")

Hope that helps,

Smitty

 

[BrianM]

I'm brain dead, I'm sorry I asked that one.

Thanks

 

[DRJ]

You're Welcome

Take Care

Hi Smitty. What's goin' on?

 

[Smitty]

I'm brain dead, I'm sorry I asked that one.

It's Friday (here anyway) and we all are! Now the posts start! :wink:

What's up Jacob - How've you been!

Have a great weekend fellas!

Smitty

 

[nehanaik25]

Thanks DRJ

=A1 + B1 worked for me

 

[pkhanna]

IT helped , thanks

 

[pkhanna]

This formula worked, thank you so much

 

[Rick Rothstein]

=TEXT(A1,"mm/dd/yy")&" " &TEXT(B1,"hh:mm:ss")

I know you realize it, but for the record, alternately...

=TEXT(A1+B1,"mm/dd/yy hh:mm:ss")