Format Time as Text
 

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.

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.

Format Time as Text
 

=TEXT(A1,"hhmm")


"bpc" wrote:

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.

Format Time as Text
 

Why do it as text why not use a format

A1 14:40
B1 =A1 and apply a custom format of HHMM

Mike

"bpc" wrote:

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.

Format Time as Text
 

While your suggestions worked, I realize now that I need the result to remain
a number and not text. Therefore, how do I remove the colon will maintaining
a number format. Thanks again.

"Teethless mama" wrote:

=TEXT(A1,"hhmm")


"bpc" wrote:

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.

Format Time as Text
 

Format as hhmm just like Mike posted

--


Regards,


Peo Sjoblom

"bpc" wrote in message
...
While your suggestions worked, I realize now that I need the result to
remain
a number and not text. Therefore, how do I remove the colon will
maintaining
a number format. Thanks again.

"Teethless mama" wrote:

=TEXT(A1,"hhmm")


"bpc" wrote:

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.

Format Time as Text
 

Change =TEXT(A1,"hhmm") to =--TEXT(A1,"hhmm")
--
David Biddulph

"bpc" wrote in message
...
While your suggestions worked, I realize now that I need the result to
remain
a number and not text. Therefore, how do I remove the colon will
maintaining
a number format. Thanks again.

"Teethless mama" wrote:

=TEXT(A1,"hhmm")


"bpc" wrote:

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.

Format Time as Text
 

That did it David thanks

"David Biddulph" wrote:

Change =TEXT(A1,"hhmm") to =--TEXT(A1,"hhmm")
--
David Biddulph

"bpc" wrote in message
...
While your suggestions worked, I realize now that I need the result to
remain
a number and not text. Therefore, how do I remove the colon will
maintaining
a number format. Thanks again.

"Teethless mama" wrote:

=TEXT(A1,"hhmm")


"bpc" wrote:

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.

Format Time as Text
 

Why text at all?

--


Regards,


Peo Sjoblom

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Change =TEXT(A1,"hhmm") to =--TEXT(A1,"hhmm")
--
David Biddulph

"bpc" wrote in message
...
While your suggestions worked, I realize now that I need the result to
remain
a number and not text. Therefore, how do I remove the colon will
maintaining
a number format. Thanks again.

"Teethless mama" wrote:

=TEXT(A1,"hhmm")


"bpc" wrote:

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.

Format Time as Text
 

That was my point which the OP chose to ignore. Such is life :(

Mike

"Peo Sjoblom" wrote:

Why text at all?

--


Regards,


Peo Sjoblom

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Change =TEXT(A1,"hhmm") to =--TEXT(A1,"hhmm")
--
David Biddulph

"bpc" wrote in message
...
While your suggestions worked, I realize now that I need the result to
remain
a number and not text. Therefore, how do I remove the colon will
maintaining
a number format. Thanks again.

"Teethless mama" wrote:

=TEXT(A1,"hhmm")


"bpc" wrote:

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.