| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Excel Date Format
Can someone provide a way to mass change time formats from tt:00 PM or AM to tA or tP. Where t=time
The minutes vary from :00, :15, :30, :45... If the minutes are other than :00 I would need the other variables :15, :30... to appear with the A or P for AM or PM. Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date format to excel format | Excel Programming | |||
| date format will not change in Excel | Excel Discussion (Misc queries) | |||
| How do I change date yyyymmdd to a Excel-supported date format? | Excel Worksheet Functions | |||
| Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
| Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming | |||
Threaded Mode
