I'm trying to organize a list of dates/times for a karaoke database I'm organizing.
I have a list of 1,276 dates/times for bars that offer karaoke at various days of the week and times. Right now it's in various formats only in one cell each as such:
Wed/Fri/Sat 8pm-2
Wed/Thu/Sat/Sun 9pm-130
Tue/Thu 9pm-2
Thursdays 8pm-1
7 Nites a Week 8pm-230
Fridays 10pm-2
Wednesdays 10pm-1
Tuesdays 7pm-9pm
Tue/Thu 9pm-2, Fri 12am-2, Sat 10pm-2
7 Nites a Week 8pm-2
I need to have a column for each day of the week with the corresponding start/finish times for each applicable day.
Pretty straightforward stuff. I've already started it, and it seems to be about a 4 hour job.