In the first row of column B (B 1), enter: suggested recovery time.
Enter the interview time (C 1) in the first row of column C.
Input by analogy: interview passing time, arrival time, department delay time, candidate delay time and recruitment cycle.
Enter the corresponding data in the second line (for example: 20 12123 February 20126 February 2012/3 February 2012).
Enter the formula =MAX (network days (B2, C2)-4,0) in F2.
Enter the formula =MAX (network days (D2, E2)-8,0) in G2.
Enter the formula in H2: = network days (A2, E2)-F2-G2.
As shown in the figure: