I have a data set that lists durations in a column as "x hours y minutes". I need to average all the durations. Does anyone know of a formula I can use to take out the words "hours" and "minutes" so that the cells either read "z minutes" or "hr:mn"?

Thanks so much!