View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Convert Text to time value

With your sample time in cell A1, I got this formula to generate
something appropriate:
=TEXT(HOUR(A1),"00")&TEXT(MINUTE(A1),"00")

....where the time in A1 is an Excel-readable time format. Does that
get you close?