Pull out numbers from a duration string

GScottMiller

A customer of ours is going to be providing data to us daily in the format of "Install Duration" I want to pull only the time out of that so I can get an average. I basically am just trying to remove "hour" or "hours"

I could do a =left() formula, but the number of decimals can change.

Im certain this is an easier formula, I just could use some help with it!

Paul Newcome

TO be able to pull an average, you also need numerical data. The LEFT function only outputs text strings.

First we use the LEFT with a FIND function to find the space and tell the left function to pull up to that.

=LEFT([Install Duration]@row, FIND(" ", [Install Duration]@row) - 1)

Then we wrap it in a VALUE function so that the output is numerical data.

=VALUE(LEFT(.......))