Exclude Pending Status duration from Spent Time on an Incident ticket of HP SM

Hello Experts,

 

I need a script or expressions on spend time calculation on Incident ticket in HP Service Manager.

IIn format control calculation what I have done is like, for capturing the Spent Time on the IM ticket is:

 

Spent TIme=resolved.time in $L.file-open.time in $L.file and I am able to capture the value in Spent Time field. But it is calculating the time even for suspended statuses..So I need to exclude the time for Suspnded status..

 

Please suggest.

 

Thanks and Regards,