| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
| getting military time format within excel | Excel Discussion (Misc queries) | |||
| Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
| Military Time | Excel Worksheet Functions | |||
| in excel totaling weekly hours military time | Excel Worksheet Functions | |||
Linear Mode
