I have 40 person everyone have one hour
everyday during 24 hours has 24 person
next day 24 person
date
17.03.2019 from 1-24 names
18.03.2019 from 25- 9 names
19.03.2019 from 10 - 34 names
Example
If the first name at 07:00 in 17.03.2019 the next time for him 12:00 in 18.03.2019 then in 20.03.2019
like this
Exactly as table everyday 24 person during the time
repeats every 14 days and 6 hours
If start in 01.03.2019 at 01:00am and repeat again
In 15.03.2019 at 07:00 am and repeat again in 30.03.2019 at 13:00 like this
That mean 14 group one group has 24 hours
I know complex but this my project also sorry my English poor
This may can do in Microsoft excal but How I can do it as applications
that means cycle the rotation every 14 days
I hope clear for you