Home How to calculate the time extends with rest time
Reply: 0

How to calculate the time extends with rest time

user974
1#
user974 Published in April 24, 2018, 8:27 am

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) & every rest time(start and end ) : 9:15 to 9:20 , 10:10-10:40

Any excel or VBA solutions to perform this ?

the sample input can be : 830-12:34 ,930-1732 , 9:30-23:67

My current working :(total minute as 158) 8:30-11: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

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.35918 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO