Power Query help needed

[Stlcardsfan]

Hoping someone can help. In power query I have a column which includes days of week and schedule ex. Saturday 9:00 am 5:00 pm Tuesday 9:00 am 5:00 pm Wednesday 9:00 am 5:00 pm. Schedules in the Column are not consistent as, different hours on different days, days are different as well. I want weekday column that would pull in the hours after a specified day. I need a way for the newly created column to look at the data string for a specified day and pull in the times listed after it. Example would be - find Tuesday in the string and return x number of spaces after it.

 

[sandy666]

use XL2BB to post representative example of source data and expected result