Forum Discussion

NeilKloster's avatar
NeilKloster
Brass Contributor
Jun 19, 2020
Solved

Trouble combining two cells into one

Hello,    I am trying to combine a date from cell A1 (=Today()) with a time from cell B1 (3:00:00 PM), but everything I try, I get:    "44001 3:00:00 PM" in C1   I've tried custom formatting, I...
excel
Formulas and Functions
  • Bennadeau's avatar
    Bennadeau
    Jun 19, 2020

    Hi NeilKloster,

    Try this ...

    =CONCATENATE(TEXT(TODAY(),"m/dd/yyyy")&" 3:00 PM")

     

    Ben

Abiola1's avatar
Abiola1
MVP
Jun 19, 2020
=TEXT(A1,"m/dd/yyyy")&" "&TEXT(B1,"hh:mm:ss")

That will deliver 6/19/2020 15:00:00

Then you can copy down the formula using autofill handle

Resources