I'm stuck with a task and i would highly appreciate the help ...
I work in a hospital, each clinic has a time period working hours and max patients daily for example:
Clinic x works from 9:00 AM till 15:30 ..each patient takes 30 minutes only. so the data in the table should look like,
Patient no / clinic id / start time / end time
1 / x / 9:00 / 9:30
2 / x / 9:30 / 10:00
3 / x / 10:00 / 10:30
any help ?!