Step 1: Click the chart, and click on the Duration data series in the diagram.

Step 2: Click on the Charts Elements button (upper right corner of Chart), check the Trendline Box, click Trendline arrow and make sure Linear is selected.

Step 1: On the Home tab select Conditional Formatting, and click Manage Rules.

Step 2: In the Conditional Formatting Rules Manager, select Show formatting rules for: This worksheet, click on the fourth rule Red Text with Strikethrough, and click Edit Rule.

Step 3: Change the formula to =$E5 < "7:00:00" and click OK

Step 1: In the name box type B4:I299 (or Click cell B4, shift-click cell I299).

Step 2: Click the INSERT tab, click the PivotChart button, and select PivotChart.

Step 3: In the Create PivotChart dialog box make sure New Worksheet is select, and click OK.

Step 4: Rename the worksheet by right-clicking on the sheet name (bottom left corner), select Rename from the context menu, and type: Billing_Pivot

Step 5: Select the fields Office and Name.

Step 6: Click-and-drag the Charge field to the Values area.

Step 7: Click-and-drag the Duration field to the Values area, then click on the new Sum of Duration box, and select Value Field Settings.

Step 8: In the Value Field Settings box, select Average, click OK.

Step 9: Again click-and-drag the Duration field to the Values area, then click on the new Sum of Duration box, and select Value Field Settings.

Step 10: In the Value Field Settings box, select Count, click OK.

The result will look like: