A) use column of type VARCHAR(255)
or:
😎 resist the temptation to create a table that looks like how the users see the data. mysql doesn't support ranges of time in one column type and you need to save the data in a mysql friendly way.
if you use a string method to save the ranges you'll be limited in how the users can search those columns. Instead, create a start date and end date of type DATATIME.
Have the GUI control how the data is entered. for example, use html to create a pull down menu of start and stop times and use javascript to control the times to something reasonable.
so your table might look like:
CREATE TABLE appointments_r_us (id INT AUTO_INCREMENT PRIMARY KEY, start_date DATETIME, end_date DATETIME);
