Formula Changes "Time" into "Decimal"

[myexcelquestions]

I am using a formula and I discovered that it automatically changes the times I enter into decimal format - but I want them to remain in "time format." I've attached a file so you can see what I mean.

Is there a way to keep them in "time" format?

[tkowal]

How about:

="Course #"&B2&", "&TEXT(C2,"h:mm AM/PM")&", "&"Instructor "&D2&", "&"Lesson "&E2

[Spencer101]

=CONCATENATE("Course #"&B2&" ",TEXT(C2,"h:mm am/pm")&", "&"Instructor "&D2&", "&"Lesson "&E2)

[myexcelquestions]

Wonderful!!! Thank you so much!

[shg]

There's no need to use both the concatenate function and the operator, Spencer:

=CONCATENATE("Course #", B2, TEXT(C2," h:mm am/pm"), ", Instructor ", D2, ", Lesson ", E2)

[Spencer101]

There's no need to use both the concatenate function and the operator, Spencer:

=CONCATENATE("Course #", B2, TEXT(C2," h:mm am/pm"), ", Instructor ", D2, ", Lesson ", E2)

Oops, my bad!
I tried it without concatenate and for some reason it didn't work.
So I put concatenate in and got distracted by the twins so forgot to take the ampersands out before posting.

(BTW - "distracted by the twins" is not a euphemism! )

[shg]

"distracted by the twins" is not a euphemism!

I have a daughter hoping for twins -- "One and done!"

[Spencer101]

Worked for me
Good luck to your daughter. It's hard work!!