| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formating military time
Hello,
I am trying to format military time in excel to display regular times (without displaying the AM/PM). For Example, I have a cell that contains 1:00:00 PM, it is displayed as 13:00, but i want it to display 1:00. Any help on this would be greatly appreciated. Many Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
| Converting standard time to military time | Excel Worksheet Functions | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions | |||
| formating military time | Excel Discussion (Misc queries) | |||
Linear Mode
