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:309:15 (first session) (45min accumulate ) ,9:159:20(1 rest time) ,9:2010:05(2 session)(90 min accumulate ) ,10:0510:10 (2 rest time) .10:1010:40 (3 session ) (reminding time 30 min =12090) , no third rest
i just want to output : 8:30 10:40(start to end) & every rest time(start and end ) : 9:15 to 9:20 , 10:1010:40
Any excel or VBA solutions to perform this ?
the sample input can be : 83012:34 ,9301732 , 9:3023:67
My current working :(total minute as 158)
8:3011:08
first calculate the duration in minute
Input :830 , 11:08
output : red line in picture : new end time , every rest time start ,every rest time end
