Hi all,

I have a series of data in format like 01 to 02 PM, 03 to 04 AM, etc. And I want to convert it to format like 1300-1400, 1500-1600. It's a pain to search and replace for each time frame.

excel sample.png

Any help would be appreciated! Thx a bunch!