Hello all,

So I have a field that is formatted as text, and shows up like this:"6 day(s) 13 hrs 12 min". I am trying to get an average for these cells, however since it is formatted as such, that isn't possible. Thus I want to convert this to something manageable, perhaps along the lines "dd/hh/mm." What is an easy way to do that?

Thank you all!
-Leo