Time to text conversion

Z

zorglub76

I have Mac's version of Office (Office 2004), but it shouldn't matter..
The problem:

I have a column in a table containing times (for some events). Data
found in the cells looks like this:
1) "20:00
2) "20:00/22:00" (starting/ending time)
Excel has automatically formated type 1 cells as "time", and type 2
cells as "text".

I need all the cells to be formatted as "text". How?

If i change the formatting of a cell, it displays something like
"0.833333" (20.00 divided by 24). The only solution I came out with is
copying the whole column to a text editor -> formatting the column as
text -> copying data from the text editor back to the reformatted
column. I could be using a function to search the cells -> check the
formatting -> transform the value (somehow). But I DON'T WANT to do
this. I guess there is some much simpler way...
 
C

Carlos Antenna

You could use another column to convert it to text with the formula:
=TEXT(A1,"hh:mm")
 
D

Dave Peterson

See your earlier post.
I have Mac's version of Office (Office 2004), but it shouldn't matter..
The problem:

I have a column in a table containing times (for some events). Data
found in the cells looks like this:
1) "20:00
2) "20:00/22:00" (starting/ending time)
Excel has automatically formated type 1 cells as "time", and type 2
cells as "text".

I need all the cells to be formatted as "text". How?

If i change the formatting of a cell, it displays something like
"0.833333" (20.00 divided by 24). The only solution I came out with is
copying the whole column to a text editor -> formatting the column as
text -> copying data from the text editor back to the reformatted
column. I could be using a function to search the cells -> check the
formatting -> transform the value (somehow). But I DON'T WANT to do
this. I guess there is some much simpler way...
Click to expand...
 
Top