Remove text "minutes" "hours" from field leaving only numeric value

[ccubbage]

The data I receive from another system looks like this:

TimeWorked
15 minutes
1 hour (60 minutes)
1 minute
5 hours (300 minutes)

I would like to strip out the text and hours value so that I can sum the minutes. Column B should look like this:

Minutes
15
60
1
300

Can anyone help me create a formula for this?

 

[bobhc]

Just use find and replace.

 

[ccubbage]

Came close with that, but I also have to remove the number in front of 'hours'. It can be any value.

 

[John Jairo V]

Hi, to all!

You can try replacing:
"*hours " <-- Without quotes (take care about the space after hours).
with nothing.

Blessings!

 

[vletm]

ccubbage
... or this way?

 

[ccubbage]

Great. Thanks to all. Works great.

 

[John Jairo V]

Hi, to all!

Another option:
=LEFT(A2,FIND(" ",A2))*IF(COUNTIF(A2,"*hou*"),60,1)

Blessings!

 

[Nebu]

Hi:

The formula John gave will give you 60 even if you make your time from 1 hour (60 minutes) to 1 hour (6 minutes).

I guess this formula will cover that glitch

=IFERROR(IF(ISTEXT(LOOKUP(2^15,SEARCH("hour",J15),J15)),MID(J15,FIND("~",SUBSTITUTE(J15," ","~",2))+2,FIND("~",SUBSTITUTE(J15," ","~",3))-FIND("~",SUBSTITUTE(J15," ","~",2))-2),LEFT(J15,FIND("~",SUBSTITUTE(J15," ","~")))),0)

Thanks