|
|
#3
10-19-2021, 12:22 AM
|
|||
|
|||
VBA Help with Time am/pm format
Hi Andrew, many thanks for updating the code much appreciated, I nearly got there but not quite! Have just run it and all working great. I forgot to add a few steps to convert e.g. 8am/5pm to 8:00am/5:00pm and the variations as below to include capital AM/PM :
Change 8am or 5pm to 8:00am or 5:00pm Change 8 am or 5 pm to 8:00am or 5:00pm Change 8a.m. or 5p.m. to 8:00am or 5:00pm Change 8 a.m. or 5 p.m. to 8:00am or 5:00pm How can I add these to the current macro? Much appreciated, Shelley 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Format number for time , hh:mm:ss,,,second appears 00 | yoshi | Excel | 4 | 04-26-2021 03:11 AM |
 How to set the table cells as time format?
|
jiaron_1230 | Word VBA | 3 | 11-15-2016 05:15 AM |
|
Changing Date/time to Australia format
|
tmeck63 | Project | 1 | 01-07-2016 09:11 PM |
| time in minute format | orajesh | Excel | 3 | 12-15-2015 12:56 AM |
| Changing format of time data | Sammael | Excel | 2 | 04-08-2012 12:13 PM |
Windows 10 
Office 2016
Threaded Mode