Hi,

I need some help with the formula for this. (please see image)

Example:
I need to get the percentage of the total time.
Call duration - (minus) (Talk time + Hold)



As shown in the image. The total time doesn't match The total should only be 6 minutes, since talk time (6mins + Valid Hold 3 mins - call duration 15 mins)

I just want to get the correct total in percentage.

Thank you

Attached Images

excel.JPG (17.7 KB, 14 views)

Cross post without links

Please read the FAQ about cross posting
Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post