Pivot Tables to Show Differences in Approval Dates

I am attaching a snippet of the excel spreadsheet that I am currently working on. I am trying to develop metrics to state how many dates it takes between each approver to sign off on this document. I thought pivot tables would be the easiest way to show that, but I am not sure what combination I need to present correctly (or if this is even the best way).

For example on row 2, the department manager approved on 8/22/17. It was approved by HR on 8/23/17, QA approved on 8/30/17, TN approved on 9/11/17, and DC signed off for final approval on 9/13/17. I would like the pivot table to easily tell me how many days it took between each approval person, which would somehow show 1d, 7d, 12d, 2d. It does not all have to be on 1 pivot table, as the number of days it took between dept. manager and HR could be a separate table, but I would be nice to have all on one.

Could you show example result(s) ?

Hi sandy666
I think you are wanting an how I envision the results to look like.

I am hoping to have the title of document and then the differences between approval dates, so in the attached example (row 2) it would look something like this:
Document Title PDM to HR HR to QA QA to TN TN to DC
SOP-11057 1d 7d 12d 2d

In my example I used helper fields, which calculated the number of days between each approval.

Such as

• HR Approval After PDM: =SUM(P2-N2)

• QA Approval After HR: =SUM(R2-P2)

• TN Approval After QA: =SUM(T2-R2)

• DC Approval After TN: =SUM(U2-T2)

• Total Approval Days: =SUM(V2:Y2)

Then I turned that in to a pivot table for reporting which consist of the Document Number, Document Title, and the fields above

see attachment

do you really need word "day(s)" after each number?
it's no problem with it but ... doesn't make sense to me

No I do not actually need days - just more so a clarification that I am wanting the difference to be represented in days

Thank you both for these responses!!! They work great I appreciate your help and quickness!

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it - ignore it.
Thank you.

here is Pivot Table without additional columns in source table