Thread
:
Convert Text to time value
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave O
Posts: n/a
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?
Reply With Quote