Converting hours/min to decimal time

I've tried finding a way to solve my problem, however I've only been able to find a solution for if the time is set up as something like 1:30 (which would be 1.5). Unfortunately, the times are collected as a text string, so that each entry is "x hour(s) x mins". I tried to find and replace the words individually, but that hasn't had any success (the word wont replace for some reason).

The other unfortunate part is that each field is not identical. If the contractor only worked 45 minutes, for example, it will say "45 mins", not "0 hours 45 min", so I can't do a consistent removal or substitute for each field because not every one says the same thing. What I have across fields is something like this;

If there is only 1 hour, it will say "hour", else it will say "hours"
If the work was less than 1 hour, there will only be "mins" and "hours" will not be present
If the work was an even amount of hours, it will only say "hours" and "mins" will not be present

So the fields are populated with an assortment of "hour" "hours" and "mins", making it hard for me to figure out how to remove them all, and convert it to a decimal place. Ultimately, I need 1 hour 30 min to = 1.5

Is there any way to do this short of editing each individual field? There are hundreds, and I have to do this bi-weekly, so I was really hoping there'd be a way.

Thanks in advance

I think I uploaded it.

The yellow fields are the ones I am trying to convert.

The field in green is what I'm hoping the end result will look like, based on the entries in the HOURS_WORKED (L) column.

Try below...
=IFERROR(LEFT(L2,SEARCH("hour",L2)-1)*1,0)+IFERROR(IF(SEARCH("mins",L2)<=4,LEFT(L2,3)/60,MID(L2,FIND("@",SUBSTITUTE(L2, " ", "@", 2)),LEN(L2)-SEARCH("mins",L2))/60),0)

Sample attached.

Oh god.. That's an insane formula. It works, so thank you so much! I'd never have figured this out on my own.

Very much appreciated! <3

Option rev 0(hilited yellow):
Try in column z=aa2+ab2
column aa=iferror(mid(l2,search("hour",l2,1)-2,1),0)
column ab=iferror(mid(l2,search("min",l2,1)-3,2),0)/60

or the best option(hilited green):
Directly type in column z=iferror(mid(l2,search("hour",l2,1)-2,1),0)+iferror(mid(l2,search("min",l2,1)-3,2),0)/60

Both of these formulas are pretty crazy. I dunno what most of it even means, but thank you both.

I'm trying to do the inverse. I want to convert the number 90 into an h:mm format. I have an Excel “Things to Do” worksheet. I’m trying to create a formula for Column E that will give me the total time required to perform tasks. My current solution tells me 1.5 hours instead of 1:30. Here’s what I have. Any help will be appreciated.

Row 1 is my Column headers
A1 is =NOW()
B1 is Things to do
C1 is Time req'd in min
D1 is Cumulative Time in min
E1 is Hours Req'd

Row 2 is a hidden row to make the formulas work and for sorting purposes.
A2 is =NOW()
B2 is 0 formula start row
C2 is 0
D2 is 0
E2 is =TEXT(D2,"H:MM")

Rows 3
A3 is =A2+TIME(0,C3,0)
B3 is Make dinner menu for the week
C3 is 30
D3 is =(C3+D2)
E3 is =D3/60

Rows 4
A4 is =A3+TIME(0,C4,0)
B4 is Make grocery list
C4 is 15
D4 is =(C4+D3)
E4 is =D4/60

That worked. Thanks.