Question: how to calculate time difference in pivot table?
Answer: In the pivot table, right-click a cell in the time field, and click Value Field Settings. In the Value Field Settings dialog box, click Number Format. In the Category list, click Custom. In the Type box, enter: [h]:mm (That format totals the hours)