Given that a start time and end time .
Like 8:30- 10:30 , so I can calculate the duration (minutes) -->120
the situation : every 45 min , a short 5 mins break will be given .
It will be 8:30-9:15 (first session) (45min accumulate ) ,9:15-9:20(1 rest time) ,9:20-10:05(2 session)(90 min accumulate ) ,10:05-10:10 (2 rest time) .10:10-10:40 (3 session ) (reminding time 30 min =120-90) , no third rest
i just want to output : 8:30 -10:40(start to end) & rest time : 9:15 to 9:20 , 10:10-10:40
Any solution to perform this ?
My current working :
Like 8:30- 10:30 , so I can calculate the duration (minutes) -->120
the situation : every 45 min , a short 5 mins break will be given .
It will be 8:30-9:15 (first session) (45min accumulate ) ,9:15-9:20(1 rest time) ,9:20-10:05(2 session)(90 min accumulate ) ,10:05-10:10 (2 rest time) .10:10-10:40 (3 session ) (reminding time 30 min =120-90) , no third rest
i just want to output : 8:30 -10:40(start to end) & rest time : 9:15 to 9:20 , 10:10-10:40
Any solution to perform this ?
My current working :
