Changing Date format using vba

Hi, I am new to using vba and have taken on a task on changing the date format in excel using vba.

 

The current format is :

M 8:30 AM-5:30 PM;
T 8:30 AM-5:30 PM;
W 8:30 AM-5:30 PM;
R 8:30 AM-5:30 PM;
F 8:30 AM-5:30 PM

 

But needs to be in this format:

M-F 8:30 AM – 5:30 PM

 

The only thing is there are over 1000 various formats as these are hours for over 1000 providers.

Does anyone have any helpful advice on how to go about this?

By: Maria

Leave a Reply

Your email address will not be published. Required fields are marked *