|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 15th, 2008, 06:00 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. 
|
|
#2
September 15th, 2008, 06:08 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#3
September 15th, 2008, 06:12 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#4
September 15th, 2008, 07:07 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#5
September 15th, 2008, 07:10 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#6
September 15th, 2008, 07:28 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#7
September 15th, 2008, 07:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#8
September 15th, 2008, 07:39 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#9
September 15th, 2008, 07:40 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
|
#10
September 15th, 2008, 07:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
