Add time to a sentence

[csilabgirl]

I have in cell M1 a time, "2:00 pm". In cell M2 I want it to say "Your appointment is at 2:00 pm". so in M2 I put

="Your Appointment is at "&M1.

But I get "Your appointment is at 14:00"

How do I get it to do what I want?

Thanks for the help!

 

[Nalani]

I'm not sure how your cell M1 is formated.

If formated as Text, and you type in all entries (2 : 0 0 pm) it will give you what you want.

 

[snoopyhr]

Excel Workbook
	A	B
1	4/12/2011 20:28	Your appointment is at: 08:28 PM
Sheet1

 

[T. Valko]

I have in cell M1 a time, "2:00 pm". In cell M2 I want it to say "Your appointment is at 2:00 pm". so in M2 I put

="Your Appointment is at "&M1.

But I get "Your appointment is at 14:00"

How do I get it to do what I want?

Thanks for the help!

Try it like this...

="Your Appointment is at "&TEXT(M1,"h:mm AM/PM")

 

[csilabgirl]

that worked great, thank you very much for the help.

 

[T. Valko]

that worked great, thank you very much for the help.

You're welcome. Thanks for the feedback!