Creating Priority-wise Resolution Time report.

Hi, I’m trying to create Priority-wise Resolution Time Report as below:

However, I’ve encountered problem to create the report. It seems that my data for Resolution Time prevents me from creating this report since its data type is String. Therefore, it can’t calculate the Average Resolution Time of the tickets. So, I tried to change the data type of Resolution Time to number/date but it was unsuccessful because of my Resolution Time written format in ‘n days n hours n minutes’ which is as below:

Is there any way that analytic plus can help me solve this problem maybe through converting the data written format into a correct written format with correct data type to produce the report above? Your help is really appreciated.

**FYI, my data is imported manually and I didn’t integrate with ServiceDesk Plus.

**Resolution Time = The time taken to resolve a ticket.