How to normalize data more efficiently?

My problem: Work Schedule data from a coworkers report is formatted for paper and she kept changing abbreviation and typos. I need to normalize it for my dashboard. Ideally in power query. We have people who work up 4 different schedules depending on the day too.

Everything is in one column, so: Work hours, work days, work hours, work days, etc.

sample data:

7am-3:30pm m-f

7:00am-11:00am M, W, F 2:00pm-9:00pm T,Th

12pm-8;30pm Mon & Fri; 4pm-12:30am Tues.-Thurs.

2pm-12:30am M&Tu , 7pm-5:30 Sat-Su

Edit: I am using 2016 excel with o365 available in browser with company restrictions on VBA, Python, and Automation.

Non essential information:

I've been working on a dashboard to show how many people are working, who they are, what company they work for, and include the ability to see who will be present during a window of time on selected days.