Thread: Convert Time to a Text
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJ CJ is offline
external usenet poster
  
Posts: 102
Default Convert Time to a Text
Thank you.

"Teethless mama" wrote:

=TEXT(A1,"hhmm")

"CJ" wrote:

Hi,

I need help with a formula. I'm trying to convert a time to text as in the
example below.

Example:
A1= 5:16 PM
B1= 1716

Thanks for any help!
Reply With QuoteReply With Quote