How do I concatenate a date and time in the same sentence?

[Trotter]

Good day Gurus....

I have two cells on a sheet named MASTER
A1 is a date formatted thus 03-Sep-16
B1 is a time formatted thus 13:30

I am trying to write
"This is to confirm our appointment for: 03-Sep-16, 13:30"

I get the date to work, but not the time, with this attempt:

=CONCATENATE("This is to confirm our appointment for: ",TEXT(MASTER!A1,"DD-MMM-YY", TIME(MASTER!B1,"hh:mm")))

I cannot see what I am doing wrong.

 

[NARAYANK991]

Hi ,

Try this :

=CONCATENATE("This is to confirm our appointment for: ",TEXT(A1,"DD-MMM-YY, "),TEXT(B1,"hh:mm"))

I think the usage of TIME was a typo , since the TIME function has a different syntax.

Narayan

 

[Khalid NGO]

Hi Trotter,
Good day and welcome to the forum...

Here is one more way with custom format. Use the simple formula:
=MASTER!A1+MASTER!B1

and then format your cell as:
"This is to confirm our appointment for: "dd-mmm-yy, hh:mm

Regards,

 

[xlstime]

Good one Khalid, extraordinary Always!!.

Hi Trotter,
Good day and welcome to the forum...

Here is one more way with custom format. Use the simple formula:
=MASTER!A1+MASTER!B1

and then format your cell as:
"This is to confirm our appointment for: "dd-mmm-yy, hh:mm

Regards,