ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why does my computer switch to military time? (https://www.excelbanter.com/excel-discussion-misc-queries/98569-why-does-my-computer-switch-military-time.html)

linzers333

Why does my computer switch to military time?
 
I am making my schedule for school this fall and all of a sudden, my 5:00 PM
switches to 17:00. All of the previous PM times are still good, but it
switches to Military Time at 5:00 PM and I cant get it to go back.

Jerry W. Lewis

Why does my computer switch to military time?
 
Internally, there is no difference between AM/PM and military time (all are
stored as decimal fractions of 24 hours). Display of time is all handled by
format. Format|Cell|Number|Time and select a suitable time format.

Jerry

"linzers333" wrote:

I am making my schedule for school this fall and all of a sudden, my 5:00 PM
switches to 17:00. All of the previous PM times are still good, but it
switches to Military Time at 5:00 PM and I cant get it to go back.



All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com