Trying to use the formula tool to turn this:
M-F,9:00AM-5:00PM;SA,7:00AM-8:00PM;SU,CLOSED
To:
MO,9:00-5:00PM;TU,9:00-5:00PM;WE,9:00-5:00PM;TH,9:00-5:00PM;FR,9:00-5:00PM;SA,8:00AM-7:00PM
Any help would be appreciated. I'm guessing something like if left 3 then MO + plus mid 7 elseif Wildcard "Closed" - Somehow trim that. The fly in the ointment is they could be close on a Tuesday.
Sometimes, the days are all spelled out due to different hours M-F. I assuming one large if-then can do it?
Solved! Go to Solution.
Works great! Thanks!