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" ?
<tbody>
</tbody>
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" ?
I entered | excel convert | custom |
1:00:00 am | 1:00:00 AM | h:mm:ss AM/PM |
1 am | 1:00 AM | h:mm AM/PM |
1:00 | 1:00 | h:mm |
1:00:00 | 1:00:00 | h:mm:ss |
<tbody>
</tbody>
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: