Excel sees my AM/PM times as text

[Monsignor]

I've formatted my cells as time.
When I enter 3:15 Excel converts it to 3:15 AM. That's ok.
But if I input 3:15 PM Excel accepts it as text.
If I type 15:15 Excel properly converts is to 3:15 PM.

I have no idea why I can't type the AM or PM and have Excel accept the value as a time.

 

[jtakw]

Hi,

When you Manually input 3:15 PM, are you sure you had a space in front of PM?
Or, may you input 3:15PM ?

 

[Monsignor]

Hi,

When you Manually input 3:15 PM, are you sure you had a space in front of PM?
Or, may you input 3:15PM ?

Yes. I'm inputting the space in between.

 

[jtakw]

Then I'm scratching my head , Excel should accept 3:15 PM as time, but 3:15PM will be Text.

 

[Monsignor]

Then I'm scratching my head , Excel should accept 3:15 PM as time, but 3:15PM will be Text.

I just tried Excel Online and it accepts 3:15 PM as a time. I don't know why my desktop version is being so stubborn.

 

[Monsignor]

I just got home and my computer at home is accepting the times like normal. Something is going on with Excel on my laptop.