Thread: Convert Time to a Text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJ CJ is offline
external usenet poster
  
Posts: 102
Default Convert Time to a Text
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