Schedule patient hours every 30 minutes and save in mysql database

Question

Good evening I need to make an appointment schedule of a medical clinic in C#. I need to list the office hours every 30 minutes, and keep only the appointment times marked in the database Mysql. But I can’t do it.