| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting format of hh:mm AM/PM to only hh:mm non 24hr in same co
Is there a way to:
Take a column that is formated to hh:mm AM/PM to remove the am or pm in the same column (Think that it would have to be text) Or Start with Text that 8:30 and make it 08:30 without the AM/PM Mic |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating 24hr Clock, but not as time!! | Excel Discussion (Misc queries) | |||
| Do not convert 24hr time in Excel to Portugese postal code | Excel Discussion (Misc queries) | |||
| how do I round hours worked to the next half hour with a 24hr shif | Excel Worksheet Functions | |||
| NEED A FORMULA TO CALCULATE DIFFERENCE BETWEEN TWO TIMES IN 24HR . | New Users to Excel | |||
| 24hr moving average | Excel Discussion (Misc queries) | |||
Threaded Mode
