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