Proper display of TIME from a formula

[JaxLarry]

I need some help with the time in a formula please.
I have this info in each cell:
Friday, September 14, 2007 - Sidewalk 65 - 8:00 PM - Tom & Betty's -
387-3311
This is the formula I am using:
=TEXT(F5,"m-dd-ddd")&G5&H5&I5&J5&K5&L5&M5&N5&O5&P5
Here is the result:
9-14-Fri - Sidewalk 65 - 0.833333333333333 - Tom & Betty's - 387-3311

It is returning 0.833333333333333 for what I would like to show as
8:00 PM

The 8:00 PM is in cell J5.

Please tell me the proper formula to make this happen. Thanks,

 

[Jason]

I think this would work:
=TEXT(J5,"h:mm am/pm")

Hope this helps.

 

[MartinW]

Hi Larry,

If I understand what you are trying to do you just need
to replace &J5& in your formula with &TEXT(J5,"h:mm am/pm")&

HTH
Martin

 

[JaxLarry]

Hi Larry,

If I understand what you are trying to do you just need
to replace &J5& in your formula with &TEXT(J5,"h:mm am/pm")&

HTH
Martin









- Show quoted text -

Thanks, that worked!

 

[MartinW]

You're welcome!

Thanks, that worked!