Format Time as Text
=TEXT(A2,"hhmm")
where A2 holds the time value
--
Regards,
Peo Sjoblom
"bpc" wrote in message
...
I have a column of time values, (formatted for example as 14:50 or 6:15). I
am flexible on the format of this column. In an adjacent column I need the
time value to be converted to text so that 14:50 reads as 1450. Simply
speaking, I need the colon removed. Thank you in advance.
|