lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
No matter how I enter the time in excel, excel will change the format to Custom (h:00:00 am/pm).
Why excel does not change the format of the time I entered to "Time" instead of "Custom" ?
[TABLE="class: grid, width: 302"]
<tbody>[TR]
[TD]I entered[/TD]
[TD]excel convert[/TD]
[TD]custom[/TD]
[/TR]
[TR]
[TD]1:00:00 am[/TD]
[TD="align: right"]1:00:00 AM[/TD]
[TD]h:mm:ss AM/PM[/TD]
[/TR]
[TR]
[TD]1 am[/TD]
[TD="align: right"]1:00 AM[/TD]
[TD]h:mm AM/PM[/TD]
[/TR]
[TR]
[TD]1:00[/TD]
[TD="align: right"]1:00[/TD]
[TD]h:mm[/TD]
[/TR]
[TR]
[TD]1:00:00[/TD]
[TD="align: right"]1:00:00[/TD]
[TD]h:mm:ss[/TD]
[/TR]
</tbody>[/TABLE]
If I click cell B3 for example and covert custom to Time excel will change it to 1:00:00 am but why excel did not accept what I entered in cell B2 1:00:00 am as Time? Excel changed it to Custom
my computer Short time is
Short h:mm tt
long h:mm:ss tt
Thank you very much.
No matter how I enter the time in excel, excel will change the format to Custom (h:00:00 am/pm).
Why excel does not change the format of the time I entered to "Time" instead of "Custom" ?
[TABLE="class: grid, width: 302"]
<tbody>[TR]
[TD]I entered[/TD]
[TD]excel convert[/TD]
[TD]custom[/TD]
[/TR]
[TR]
[TD]1:00:00 am[/TD]
[TD="align: right"]1:00:00 AM[/TD]
[TD]h:mm:ss AM/PM[/TD]
[/TR]
[TR]
[TD]1 am[/TD]
[TD="align: right"]1:00 AM[/TD]
[TD]h:mm AM/PM[/TD]
[/TR]
[TR]
[TD]1:00[/TD]
[TD="align: right"]1:00[/TD]
[TD]h:mm[/TD]
[/TR]
[TR]
[TD]1:00:00[/TD]
[TD="align: right"]1:00:00[/TD]
[TD]h:mm:ss[/TD]
[/TR]
</tbody>[/TABLE]
If I click cell B3 for example and covert custom to Time excel will change it to 1:00:00 am but why excel did not accept what I entered in cell B2 1:00:00 am as Time? Excel changed it to Custom
my computer Short time is
Short h:mm tt
long h:mm:ss tt
Thank you very much.
Last edited: