Cannot format cells for time

---

steu wrote:

I am using Office 2010 w. Windows 10. I want to format cells for TIME. I select Format cells, Time and then Type= 13:30.

 

Whatever I enter comes up as 1/11/1900 12:00:00.

 

I also tried to use Custom with Type=h:mm, same result.

 

Is this some kind of a known bug? If not, how do I format cells to be Type=13:30  ?

 

Thanks

 

---

Hi, as you want to set the time format 13:30 (military time format) in cell, then

- Type 13:30 in any cell assume that A1 cell.

- Click on A1 cell to select it.

- Look at the formula bar and make sure that it shows 1:30:00 PM.

- If it shows, then your time format is already set. If not then you must clear the Cell Formatting by copy and paste a fresh blank cell in A1.

Hope this will help you.

Hi steu,

In my PC also, it shows year 1900, but time comes correctly.

Try "Ctrl + Shift + ;"

Then change to your custome time and apply format as you want.