In cell , enter the following formula: =(D2 + (4*E2) + F2)/6 Drag this down for all your tasks.

: You can define relationships by listing "Predecessors" or "Successors" for each task ID, ensuring the project flow is logical. How to Use a PERT Chart Template in Excel

The PERT formula calculates a weighted average to find the : $$TE = \fracO + 4M + P6$$