We require an aggregated formula which uses the Desk ticket modification time based on a text field

We require an aggregated formula which uses the Desk ticket modification time based on a text field

We want to create a monthly average time report calculated by the difference of the ticket creation time and the modification time from Desk which is based on a specific text type field called "quotation no".

Is it possible to create an aggregated formula which can use the ticket modification time based on the content of a text field?