Cannot calculate the Sum

[Mahendrajain]

Hi team,

I created a form where I need to capture the total time spent on each activity. However, on the file under the total time I see an extra symbol before the number (example: '6) due to this, I'm not able to sum the calculation via the Pivot table.

Please help me in resolving this issue.

Thank you,

Mahendra

[#2]

Hello @Mahendrajain,

You can Find and Replace the extra symbols with Ctrl + H:

Or, you can substitute extra symbols like ' with =SUBSTITUTE(A1,"'",""):