Macro for finding points of time which are available and setting new points according to input parameters

[dezinsektor]

Hy everyone, this one is difficult, even to explain.
Idea is to make a macro which will scan what time periods are available and then set the START and END times for a new unit, but there must be at least 15 minutes gap between all units' working time.
The unit working time is between START and END - pretty self explanatory
So, time periods between all START and END times are not available. After 24 hours of unit RESET time next START time must be RESET time. Therefore, for let's say unit MB-34, 5th START should be 1st START (not 10:50:40 like in table) which is RESET time and that is true for all units after their 24 hour cycle.
If I want to introduce a new unit with unique IDLE TIME and RUNING TIME, I want that all start and end times are calculated for this new unit having in mind above mentioned and not changing the data (IDLE, RUNNING, RESET, START and END times) for old units.

DATA

Unit

Idle time [hours]

running time

reset time

1st start

end

2nd start

end

3rd start

end

4th start

end

5th start

end

6th start

end

7th start

end

MB-34

6:00:00

0:05:10

10:30:00

10:30:00​

10:35:10​

16:35:10​

16:40:20​

22:40:20​

22:45:30​

4:45:30​

4:50:40​

10:50:40​

-> reset time

MB-41

6:00:00

0:01:30

12:30:00

12:30:00​

12:31:30​

18:31:30​

18:33:00​

0:33:00​

0:34:30​

6:34:30​

6:36:00​

12:36:00​

-> reset time

MB-42

6:00:00

0:02:45

14:30:00

14:30:00​

14:32:45​

20:32:45​

20:35:30​

2:35:30​

2:38:15​

8:38:15​

8:41:00​

14:41:00​

-> reset time

MB-47

4:00:00

0:03:30

9:30:00

9:30:00​

9:33:30​

13:33:30​

13:37:00​

17:37:00​

17:40:30​

21:40:30​

21:44:00​

1:44:00​

1:47:30​

5:47:30​

5:51:00​

9:51:00​

-> reset time

MB-51

24:00:00

0:00:40

16:00:00

16:00:00​

16:00:40​

16:00:40​

-> reset time

MB-8

6:00:00

0:01:20

11:00:00

11:00:00​

11:01:20​

17:01:20​

17:02:40​

23:02:40​

23:04:00​

5:04:00​

5:05:20​

11:05:20​

-> reset time

MB-32

24:00:00

0:01:30

15:00:00

15:00:00​

15:01:30​

15:01:30​

-> reset time

MB-49

8:00:00

0:01:10

11:30:00

11:30:00​

11:31:10​

19:31:10​

19:32:20​

3:32:20​

3:33:30​

11:33:30​

reset time

New unit

reset time

this is the time when unit starts to function, after 24 hours unit must start again at this time, it cannot start after that time!

Thank you, I am sorry for posting table in this form but I cannot install Free XL2BB Add-in (due to admin restrictions on my computer).
I can send you Excel file if you want.

Cheers!
dezinsektor

 

[Marc L]

Hi,​

​

as you can link your workbook to a files host website like Dropbox for example …​

​

 

[dezinsektor]

povremeni plinski lift.xlsx

drive.google.com