Using calculated time ave to create a Pivot Table

I have a spreadsheet where I've calculated the time to send out a form via a formula, if(sum(b2-a2)>0, sum(b2-a2), 0).  

Can I use this calculated field in a Pivot Table where I can ave these times?
Rrave26Asked:
Who is Participating?
 
byundtConnect With a Mentor Commented:
Did you try creating a PivotTable and encounter trouble? It ought to work even if one of the columns gets its values from a formula.

I also suggest you consider this formula as an alternative to your IF & SUM formula:
=MAX(0,B2-A2)
0
 
Pratima PharandeCommented:
I aslo thought there is no problem in doing that.
Can you share your excel with dummy data with us so that it will more clear
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.