| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding a colon to military time
I need to add a colon to military time. I need to change it from 1700 to
17:00. I want it to stay in military time. I don't want am or pm to show. I can't figure out how to do this on the worksheet. Anyone know how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Military time... | Excel Discussion (Misc queries) | |||
| military time | Excel Discussion (Misc queries) | |||
| Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions | |||
| How can Excel do daily timesheet, -lunch time, & not use colon in. | Excel Worksheet Functions | |||
| adding military time format | Excel Discussion (Misc queries) | |||
Threaded Mode
