Skip to Main Content

how to split time range into 30 min. for each row

MGhobashiMay 29 2019 — edited May 31 2019

Hello,

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 ?!

Thanks

Comments
Post Details
Added on May 29 2019
6 comments
738 views