Calculate Work-back Schedule - Business Days and Hours

J

jlapid

New Member
Joined
Oct 26, 2019
Messages
2
Hello,

I am trying to create a work-back schedule where you enter a launch date/time and the delivery dates of that project are calculated based on hours working backward from that launch date. The working hours should only be business days and hours (M-F, non-holidays, 9am-5pm).

The formulas I have seem to be working properly if the launch date is within the business day/hours but not when it is outside of that.

Any help would be appreciated.


workback%20schedule.jpg

workback%20schedule.jpg






Assets Due:
=IF(17-MOD($C$13,1)*24< D7,$C$13+D7/24,WORKDAY($C$13,1+INT((D7-(17-MOD($C$13,1)*24))/8))+"09:00"+MOD((D7-(17-MOD($C$13,1)*24)),8)/24)

eProof Delivery:
=IF(17-MOD($C$13,1)*24< D8,$C$13+D8/24,WORKDAY($C$13,1+INT((D8-(17-MOD($C$13,1)*24))/8))+"09:00"+MOD((D8-(17-MOD($C$13,1)*24)),8)/24)

Count Delivery:
=IF(17-MOD($C$13,1)*24< D9,$C$13+D9/24,WORKDAY($C$13,1+INT((D9-(17-MOD($C$13,1)*24))/8))+"09:00"+MOD((D9-(17-MOD($C$13,1)*24)),8)/24)

Major Changes request by:
=IF(17-MOD($C$13,1)*24< D10,$C$13+D10/24,WORKDAY($C$13,1+INT((D10-(17-MOD($C$13,1)*24))/8))+"09:00"+MOD((D10-(17-MOD($C$13,1)*24)),8)/24)

Minor Changes request by:
=IF(17-MOD($C$13,1)*24< D11,$C$13+D11/24,WORKDAY($C$13,1+INT((D11-(17-MOD($C$13,1)*24))/8))+"09:00"+MOD((D11-(17-MOD($C$13,1)*24)),8)/24)

Final Approval Date and Time:
=IF(17-MOD($C$13,1)*24< D12,$C$13+D12/24,WORKDAY($C$13,1+INT((D12-(17-MOD($C$13,1)*24))/8))+"09:00"+MOD((D12-(17-MOD($C$13,1)*24)),8)/24)

Here's a link to the workbook
https://www.dropbox.com/s/bj1b9j9hx1l1acj/workback schedule.xlsx?dl=0
 
Last edited by a moderator:

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
The formulas I have seem to be working properly if the launch date is within the business day/hours but not when it is outside of that.
Click to expand...

Formulas could be based instead on calculated DEADLINE DATE and DEADLINE TIME
(the date and time that the work needs to be completed to satisfy workday constraints)

Deadline Date and Deadline Time
= Launch Date and Time (LD = working day LT = 9am -5pm)
OR
= 5pm on Launch Date (LD = working day LT = after 5pm)
OR
= 5pm on day prior to Launch Date (LD = working day LT = before 9am)
OR
= 5pm on previously available working day if any of the above calculated dates are non working dates

Use workings to derive both Deadline Date and Deadline Time from Launch Date and Launch Time as illustrated below
- note formulas in columns C, D and E

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][th]
B​
[/th][th]
C​
[/th][th]
D​
[/th][th]
E​
[/th][th]
F​
[/th][th]
G​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td]Launch
Date[/td][td]Launch
Time[/td][td]Lookup
Date[/td][td]DEADLINE
DATE[/td][td]DEADLINE
TIME[/td][td] FORMULA copied down[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td]
01-Dec​
[/td][td]
5:00 AM​
[/td][td]
30-Nov​
[/td][td]
29-Nov​
[/td][td]
17:00​
[/td][td] =IF(B2<9/24,A2-1,A2)[/td][td] C2[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td]
01-Dec​
[/td][td]
8:30 AM​
[/td][td]
30-Nov​
[/td][td]
29-Nov​
[/td][td]
17:00​
[/td][td] =INDEX(WorkDays,MATCH(C2,WorkDays,1))[/td][td] D2[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td]
01-Dec​
[/td][td]
12:00 PM​
[/td][td]
01-Dec​
[/td][td]
29-Nov​
[/td][td]
12:00​
[/td][td] =IF(AND(B2>=9/24,B2<=17/24),B2,17/24)[/td][td] E4[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td]
01-Dec​
[/td][td]
4:30 PM​
[/td][td]
01-Dec​
[/td][td]
29-Nov​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td]
01-Dec​
[/td][td]
7:00 PM​
[/td][td]
01-Dec​
[/td][td]
29-Nov​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7​
[/td][td]
02-Dec​
[/td][td]
5:00 AM​
[/td][td]
01-Dec​
[/td][td]
29-Nov​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8​
[/td][td]
02-Dec​
[/td][td]
8:30 AM​
[/td][td]
01-Dec​
[/td][td]
29-Nov​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9​
[/td][td]
02-Dec​
[/td][td]
12:00 PM​
[/td][td]
02-Dec​
[/td][td]
02-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10​
[/td][td]
02-Dec​
[/td][td]
4:30 PM​
[/td][td]
02-Dec​
[/td][td]
02-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11​
[/td][td]
02-Dec​
[/td][td]
7:00 PM​
[/td][td]
02-Dec​
[/td][td]
02-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12​
[/td][td]
15-Dec​
[/td][td]
5:00 AM​
[/td][td]
14-Dec​
[/td][td]
13-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13​
[/td][td]
15-Dec​
[/td][td]
8:30 AM​
[/td][td]
14-Dec​
[/td][td]
13-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14​
[/td][td]
15-Dec​
[/td][td]
12:00 PM​
[/td][td]
15-Dec​
[/td][td]
13-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
15​
[/td][td]
15-Dec​
[/td][td]
4:30 PM​
[/td][td]
15-Dec​
[/td][td]
13-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
16​
[/td][td]
15-Dec​
[/td][td]
7:00 PM​
[/td][td]
15-Dec​
[/td][td]
13-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
17​
[/td][td]
16-Dec​
[/td][td]
5:00 AM​
[/td][td]
15-Dec​
[/td][td]
13-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
18​
[/td][td]
16-Dec​
[/td][td]
8:30 AM​
[/td][td]
15-Dec​
[/td][td]
13-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
19​
[/td][td]
16-Dec​
[/td][td]
12:00 PM​
[/td][td]
16-Dec​
[/td][td]
16-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
20​
[/td][td]
16-Dec​
[/td][td]
4:30 PM​
[/td][td]
16-Dec​
[/td][td]
16-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
21​
[/td][td]
16-Dec​
[/td][td]
7:00 PM​
[/td][td]
16-Dec​
[/td][td]
16-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
22​
[/td][td]
18-Dec​
[/td][td]
5:00 AM​
[/td][td]
17-Dec​
[/td][td]
17-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
23​
[/td][td]
18-Dec​
[/td][td]
8:30 AM​
[/td][td]
17-Dec​
[/td][td]
17-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
24​
[/td][td]
18-Dec​
[/td][td]
12:00 PM​
[/td][td]
18-Dec​
[/td][td]
18-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
25​
[/td][td]
18-Dec​
[/td][td]
4:30 PM​
[/td][td]
18-Dec​
[/td][td]
18-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
26​
[/td][td]
18-Dec​
[/td][td]
7:00 PM​
[/td][td]
18-Dec​
[/td][td]
18-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
27​
[/td][td]
19-Dec​
[/td][td]
5:00 AM​
[/td][td]
18-Dec​
[/td][td]
18-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
28​
[/td][td]
19-Dec​
[/td][td]
8:30 AM​
[/td][td]
18-Dec​
[/td][td]
18-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
29​
[/td][td]
19-Dec​
[/td][td]
12:00 PM​
[/td][td]
19-Dec​
[/td][td]
19-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
30​
[/td][td]
19-Dec​
[/td][td]
4:30 PM​
[/td][td]
19-Dec​
[/td][td]
19-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
31​
[/td][td]
19-Dec​
[/td][td]
7:00 PM​
[/td][td]
19-Dec​
[/td][td]
19-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
32​
[/td][td]
20-Dec​
[/td][td]
5:00 AM​
[/td][td]
19-Dec​
[/td][td]
19-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
33​
[/td][td]
20-Dec​
[/td][td]
8:30 AM​
[/td][td]
19-Dec​
[/td][td]
19-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
34​
[/td][td]
20-Dec​
[/td][td]
12:00 PM​
[/td][td]
20-Dec​
[/td][td]
20-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
35​
[/td][td]
20-Dec​
[/td][td]
4:30 PM​
[/td][td]
20-Dec​
[/td][td]
20-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
36​
[/td][td]
20-Dec​
[/td][td]
7:00 PM​
[/td][td]
20-Dec​
[/td][td]
20-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
37​
[/td][td]
21-Dec​
[/td][td]
5:00 AM​
[/td][td]
20-Dec​
[/td][td]
20-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
38​
[/td][td]
21-Dec​
[/td][td]
8:30 AM​
[/td][td]
20-Dec​
[/td][td]
20-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
39​
[/td][td]
21-Dec​
[/td][td]
12:00 PM​
[/td][td]
21-Dec​
[/td][td]
20-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
40​
[/td][td]
21-Dec​
[/td][td]
4:30 PM​
[/td][td]
21-Dec​
[/td][td]
20-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
41​
[/td][td]
21-Dec​
[/td][td]
7:00 PM​
[/td][td]
21-Dec​
[/td][td]
20-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
42​
[/td][td]
22-Dec​
[/td][td]
5:00 AM​
[/td][td]
21-Dec​
[/td][td]
20-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
43​
[/td][td]
22-Dec​
[/td][td]
8:30 AM​
[/td][td]
21-Dec​
[/td][td]
20-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
44​
[/td][td]
22-Dec​
[/td][td]
12:00 PM​
[/td][td]
22-Dec​
[/td][td]
20-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
45​
[/td][td]
22-Dec​
[/td][td]
4:30 PM​
[/td][td]
22-Dec​
[/td][td]
20-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
46​
[/td][td]
22-Dec​
[/td][td]
7:00 PM​
[/td][td]
22-Dec​
[/td][td]
20-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
47​
[/td][td]
23-Dec​
[/td][td]
5:00 AM​
[/td][td]
22-Dec​
[/td][td]
20-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
48​
[/td][td]
23-Dec​
[/td][td]
8:30 AM​
[/td][td]
22-Dec​
[/td][td]
20-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
49​
[/td][td]
23-Dec​
[/td][td]
12:00 PM​
[/td][td]
23-Dec​
[/td][td]
23-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
50​
[/td][td]
23-Dec​
[/td][td]
4:30 PM​
[/td][td]
23-Dec​
[/td][td]
23-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
51​
[/td][td]
23-Dec​
[/td][td]
7:00 PM​
[/td][td]
23-Dec​
[/td][td]
23-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
52​
[/td][td]
24-Dec​
[/td][td]
5:00 AM​
[/td][td]
23-Dec​
[/td][td]
23-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
53​
[/td][td]
24-Dec​
[/td][td]
8:30 AM​
[/td][td]
23-Dec​
[/td][td]
23-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
54​
[/td][td]
24-Dec​
[/td][td]
12:00 PM​
[/td][td]
24-Dec​
[/td][td]
24-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
55​
[/td][td]
24-Dec​
[/td][td]
4:30 PM​
[/td][td]
24-Dec​
[/td][td]
24-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
56​
[/td][td]
24-Dec​
[/td][td]
7:00 PM​
[/td][td]
24-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
57​
[/td][td]
25-Dec​
[/td][td]
5:00 AM​
[/td][td]
24-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
58​
[/td][td]
25-Dec​
[/td][td]
8:30 AM​
[/td][td]
24-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
59​
[/td][td]
25-Dec​
[/td][td]
12:00 PM​
[/td][td]
25-Dec​
[/td][td]
24-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
60​
[/td][td]
25-Dec​
[/td][td]
4:30 PM​
[/td][td]
25-Dec​
[/td][td]
24-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
61​
[/td][td]
25-Dec​
[/td][td]
7:00 PM​
[/td][td]
25-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
62​
[/td][td]
26-Dec​
[/td][td]
5:00 AM​
[/td][td]
25-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
63​
[/td][td]
26-Dec​
[/td][td]
8:30 AM​
[/td][td]
25-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
64​
[/td][td]
26-Dec​
[/td][td]
12:00 PM​
[/td][td]
26-Dec​
[/td][td]
24-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
65​
[/td][td]
26-Dec​
[/td][td]
4:30 PM​
[/td][td]
26-Dec​
[/td][td]
24-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
66​
[/td][td]
26-Dec​
[/td][td]
7:00 PM​
[/td][td]
26-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
67​
[/td][td]
27-Dec​
[/td][td]
5:00 AM​
[/td][td]
26-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
68​
[/td][td]
27-Dec​
[/td][td]
8:30 AM​
[/td][td]
26-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
69​
[/td][td]
27-Dec​
[/td][td]
12:00 PM​
[/td][td]
27-Dec​
[/td][td]
24-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
70​
[/td][td]
27-Dec​
[/td][td]
4:30 PM​
[/td][td]
27-Dec​
[/td][td]
24-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
71​
[/td][td]
27-Dec​
[/td][td]
7:00 PM​
[/td][td]
27-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
72​
[/td][td]
28-Dec​
[/td][td]
5:00 AM​
[/td][td]
27-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
73​
[/td][td]
28-Dec​
[/td][td]
8:30 AM​
[/td][td]
27-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
74​
[/td][td]
28-Dec​
[/td][td]
12:00 PM​
[/td][td]
28-Dec​
[/td][td]
24-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
75​
[/td][td]
28-Dec​
[/td][td]
4:30 PM​
[/td][td]
28-Dec​
[/td][td]
24-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
76​
[/td][td]
28-Dec​
[/td][td]
7:00 PM​
[/td][td]
28-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
77​
[/td][td]
29-Dec​
[/td][td]
5:00 AM​
[/td][td]
28-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
78​
[/td][td]
29-Dec​
[/td][td]
8:30 AM​
[/td][td]
28-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
79​
[/td][td]
29-Dec​
[/td][td]
12:00 PM​
[/td][td]
29-Dec​
[/td][td]
24-Dec​
[/td][td]
12:00​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
80​
[/td][td]
29-Dec​
[/td][td]
4:30 PM​
[/td][td]
29-Dec​
[/td][td]
24-Dec​
[/td][td]
16:30​
[/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
81​
[/td][td]
29-Dec​
[/td][td]
7:00 PM​
[/td][td]
29-Dec​
[/td][td]
24-Dec​
[/td][td]
17:00​
[/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet6[/td][/tr][/table]

Column D uses Named Range WorkDays - these are the working days in December (hence 24 December deadline for many rows) - illustrated below

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td]Working
Dates
Earliest to
Latest[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td]
29-Nov​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td]
02-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td]
03-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td]
04-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td]
05-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7​
[/td][td]
06-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8​
[/td][td]
09-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9​
[/td][td]
10-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10​
[/td][td]
11-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11​
[/td][td]
12-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12​
[/td][td]
13-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13​
[/td][td]
16-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14​
[/td][td]
17-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
15​
[/td][td]
18-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
16​
[/td][td]
19-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
17​
[/td][td]
20-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
18​
[/td][td]
23-Dec​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
19​
[/td][td]
24-Dec​
[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: WorkDays[/td][/tr][/table]


Comment
Some of my assumptions may be incorrect, but the general approach should work
I did not download your workbook
 
Upvote 0
Thanks Yongle, I like the idea of breaking out the date and time into separate columns and formulas but I am struggling how you apply the number of hours it takes to "do the work".

In my original screenshot the column header of "1-2 versions" lists out how many business hours prior to the launch time we need to calculate what you are calling the "deadline time".
 
Upvote 0
How about this as a much simpler approach to everything

1. Create a lookup list of valid working dates and hours starting 9 am - 5pm (see below)
(9 rows per day , approx 2,500 rows per annum - so 10 years into future are only 25,000 rows)

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td]Working Date and Times[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td]
13/12/2019 09:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td]
13/12/2019 10:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td]
13/12/2019 11:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td]
13/12/2019 12:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td]
13/12/2019 13:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7​
[/td][td]
13/12/2019 14:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8​
[/td][td]
13/12/2019 15:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9​
[/td][td]
13/12/2019 16:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10​
[/td][td]
13/12/2019 17:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11​
[/td][td]
16/12/2019 09:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12​
[/td][td]
16/12/2019 10:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13​
[/td][td]
16/12/2019 11:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14​
[/td][td]
16/12/2019 12:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
15​
[/td][td]
16/12/2019 13:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
16​
[/td][td]
16/12/2019 14:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
17​
[/td][td]
16/12/2019 15:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
18​
[/td][td]
16/12/2019 16:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
19​
[/td][td]
16/12/2019 17:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
20​
[/td][td]
17/12/2019 09:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
21​
[/td][td]
17/12/2019 10:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
22​
[/td][td]
17/12/2019 11:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
23​
[/td][td]
17/12/2019 12:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
24​
[/td][td]
17/12/2019 13:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
25​
[/td][td]
17/12/2019 14:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
26​
[/td][td]
17/12/2019 15:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
27​
[/td][td]
17/12/2019 16:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
28​
[/td][td]
17/12/2019 17:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
29​
[/td][td]
18/12/2019 09:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
30​
[/td][td]
18/12/2019 10:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
31​
[/td][td]
18/12/2019 11:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
32​
[/td][td]
18/12/2019 12:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
33​
[/td][td]
18/12/2019 13:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
34​
[/td][td]
18/12/2019 14:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
35​
[/td][td]
18/12/2019 15:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
36​
[/td][td]
18/12/2019 16:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
37​
[/td][td]
18/12/2019 17:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
38​
[/td][td]
19/12/2019 09:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
39​
[/td][td]
19/12/2019 10:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
40​
[/td][td]
19/12/2019 11:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
41​
[/td][td]
19/12/2019 12:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
42​
[/td][td]
19/12/2019 13:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
43​
[/td][td]
19/12/2019 14:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
44​
[/td][td]
19/12/2019 15:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
45​
[/td][td]
19/12/2019 16:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
46​
[/td][td]
19/12/2019 17:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
47​
[/td][td]
20/12/2019 09:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
48​
[/td][td]
20/12/2019 10:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
49​
[/td][td]
20/12/2019 11:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
50​
[/td][td]
20/12/2019 12:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
51​
[/td][td]
20/12/2019 13:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
52​
[/td][td]
20/12/2019 14:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
53​
[/td][td]
20/12/2019 15:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
54​
[/td][td]
20/12/2019 16:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
55​
[/td][td]
20/12/2019 17:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
56​
[/td][td]
23/12/2019 09:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
57​
[/td][td]
23/12/2019 10:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
58​
[/td][td]
23/12/2019 11:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
59​
[/td][td]
23/12/2019 12:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
60​
[/td][td]
23/12/2019 13:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
61​
[/td][td]
23/12/2019 14:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
62​
[/td][td]
23/12/2019 15:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
63​
[/td][td]
23/12/2019 16:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
64​
[/td][td]
23/12/2019 17:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
65​
[/td][td]
24/12/2019 09:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
66​
[/td][td]
24/12/2019 10:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
67​
[/td][td]
24/12/2019 11:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
68​
[/td][td]
24/12/2019 12:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
69​
[/td][td]
24/12/2019 13:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
70​
[/td][td]
24/12/2019 14:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
71​
[/td][td]
24/12/2019 15:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
72​
[/td][td]
24/12/2019 16:00​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
73​
[/td][td]
24/12/2019 17:00​
[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: LookUp[/td][/tr][/table]

2. That List can be looked up and offset based on end time to determine stat time of each task as illustrated beow
"List" is name of named range with RefersTo =LookUp!$A:$A

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]
A​
[/th][th]
B​
[/th][th]
C​
[/th][th]
D​
[/th][th]
E​
[/th][th]
F​
[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
1​
[/td][td]TASK[/td][td]Time taken[/td][td]End Time
(delivery time
is known)[/td][td] In C3
copied down[/td][td]Start Time[/td][td] In E2
copied down[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
2​
[/td][td]Task5[/td][td]
2​
[/td][td]
24/12/2019 16:00​
[/td][td][/td][td]
24/12/2019 14:00​
[/td][td] =INDEX(List,MATCH(C2,List,1)-B2)[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
3​
[/td][td]Task4[/td][td]
15​
[/td][td]
24/12/2019 14:00​
[/td][td] =E2[/td][td]
20/12/2019 17:00​
[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
4​
[/td][td]Task3[/td][td]
20​
[/td][td]
20/12/2019 17:00​
[/td][td][/td][td]
18/12/2019 15:00​
[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
5​
[/td][td]Task2[/td][td]
5​
[/td][td]
18/12/2019 15:00​
[/td][td][/td][td]
18/12/2019 10:00​
[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
6​
[/td][td]Task1[/td][td]
19​
[/td][td]
18/12/2019 10:00​
[/td][td][/td][td]
16/12/2019 09:00​
[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
7​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
8​
[/td][td]PROOF[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
9​
[/td][td]Total hours =[/td][td]
61​
[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
10​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
11​
[/td][td]End time row[/td][td]
72​
[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
12​
[/td][td]Start time row[/td][td]
11​
[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
13​
[/td][td]Time taken[/td][td]
61​
[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
14​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]
15​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Task[/td][/tr][/table]
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Hours Between 2 Dates Excluding Non-Business Hours ONLY
Replies
7
Views
526
felixstraube
F
R
  • Solved
Adding Hours & Minutes to Dates & Times w/in Working Hours
2
Replies
11
Views
614
Asbestos_Jen
Asbestos_Jen
K
  • Solved
How to sum up working hours (a different schedule)
Replies
9
Views
333
KarolinaKaralaite
K
D
  • Question Question
Formula help needed for working with days and times.
Replies
0
Views
316
dshtesy
D
V
  • Question Question
Hours functions
Replies
4
Views
565
jkpieterse
jkpieterse

Forum statistics

Threads
1,223,884
Messages
6,175,171
Members
452,615
Latest member
bogeys2birdies

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top