text to time

[lezawang]

Hi
I highlight cells A1:A3 and changed the format to Text. Then I entered time

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]1:00[/TD]
[/TR]
[TR]
[TD]2:00[/TD]
[/TR]
[TR]
[TD]3:00[/TD]
[/TR]
</tbody>[/TABLE]

They are all aligned to the left. So far so good. Then I highlighted them again and changed the format to Time.
Nothing changed!!. What I needed to do is to double click on each cell, for example I double clicked on cell A1
then the value would change to 1:00:00 AM.

Why when I highlighted the cells and changed the format to Time, nothing happened? When I needed to double click on each cell to make the change happen? thank you very much.

 

[sandy666]

I highlight cells A1:A3 and changed the format to Text. Then I entered time

do exactly the same, highlight, change format and enter time

 

[lezawang]

Thank you. But let me explain why I am confused about this. Let say A1 value is 1

I click on A1 and change the format to Short date, I will get 1/1/1900
then I click on the A1 again and I change the format to General and I will get 1

So I did not need to double click on A1 to change 1 to 1/1/1900 or 1/1/1900 to 1

Why with the time I had to double click on the cell? Thank you.

 

[sandy666]

Why with the time I had to double click on the cell?

dbl click and enter is the same as I said: re-enter time (after changing format)

Excel has many ways to do the same things

 

[lezawang]

But why I need to re-enter them. They are already there. Let say I have 100 of them. Do I need to re-enter them again. Thank you very much.

 

[sandy666]

test it: enter time, change format to text, then change format to general then change format to time. don't change format of the cell before entering time

if you want more use Alt+Q or F1