How to convert rows of times in Xh Ym format into usable numbers?

[charlesstricklin]

Lyft formats my times booked & online in the format below. Is there any way (no VBA scripts, please) to massage this data so that columns E & F can show a usable sum at the bottom? Maybe in the same format, total minutes only, or even add columns to separate hours and minutes for each. I realize this is probably a big ask but you folks must love challenges.

FYI As best I can calculate Booked Time totals 106h 700m or 117h 40m, and the Online Time should come out to 1,098m or 187h 18m. (I think)

(No offense intended to the VBA enthusiasts, but I'd just rather keep things plain.)

2024 Earnings.xlsx
	E	F
1	Booked Time	Online Time
2	4h 53m	7h 51m
3	1h 15m	2hr 6m
4	11h 56m	19h 8m
5	56m	1h 45m
6	2h 29m	3h 46m
7	4h 52m	6h 24m
8	2h 30m	4h 14m
9	52m	1h 52m
10	19h 33m	24h 17m
11	15h 59m	21h 6m
12	16h 8m	18h 46m
13	3h 3m	3h 9m
14	44m	3h 30m
15	1h 54m	2h 55m
16	6h 27m	11h 41m
17	2h 40m	6h 9m
18	5h 43m	10h 4m
19	15h 46m	28h 35m
Lyft Earnings

 

[Cubist]

Maybe this.

Book1
	E	F	G	H
1	Booked Time	Online Time	Booked Time Hours	Online Time Hours
2	4h 53m	7h 51m	4.88	7.85
3	1h 15m	2hr 6m	1.25	2.10
4	11h 56m	19h 8m	11.93	19.13
5	56m	1h 45m	0.93	1.75
6	2h 29m	3h 46m	2.48	3.77
7	4h 52m	6h 24m	4.87	6.40
8	2h 30m	4h 14m	2.50	4.23
9	52m	1h 52m	0.87	1.87
10	19h 33m	24h 17m	19.55	24.28
11	15h 59m	21h 6m	15.98	21.10
12	16h 8m	18h 46m	16.13	18.77
13	3h 3m	3h 9m	3.05	3.15
14	44m	3h 30m	0.73	3.50
15	1h 54m	2h 55m	1.90	2.92
16	6h 27m	11h 41m	6.45	11.68
17	2h 40m	6h 9m	2.67	6.15
18	5h 43m	10h 4m	5.72	10.07
19	15h 46m	28h 35m	15.77	28.58
20
21	Total Hours		117.67	177.30
Sheet1

Cell Formulas
Range	Formula
G2:H19	G2	=LET(h,IFERROR(--LEFT(E2,SEARCH("h",E2)-1),0),s,SUBSTITUTE(E2,"m",""),m,--IFERROR(MID(s,SEARCH(" ",s),3),s),h+m/60)
G21:H21	G21	=SUM(G2:G19)

 

[charlesstricklin]

Maybe this.

Book1
	E	F	G	H
1	Booked Time	Online Time	Booked Time Hours	Online Time Hours
2	4h 53m	7h 51m	4.88	7.85
3	1h 15m	2hr 6m	1.25	2.10
4	11h 56m	19h 8m	11.93	19.13
5	56m	1h 45m	0.93	1.75
6	2h 29m	3h 46m	2.48	3.77
7	4h 52m	6h 24m	4.87	6.40
8	2h 30m	4h 14m	2.50	4.23
9	52m	1h 52m	0.87	1.87
10	19h 33m	24h 17m	19.55	24.28
11	15h 59m	21h 6m	15.98	21.10
12	16h 8m	18h 46m	16.13	18.77
13	3h 3m	3h 9m	3.05	3.15
14	44m	3h 30m	0.73	3.50
15	1h 54m	2h 55m	1.90	2.92
16	6h 27m	11h 41m	6.45	11.68
17	2h 40m	6h 9m	2.67	6.15
18	5h 43m	10h 4m	5.72	10.07
19	15h 46m	28h 35m	15.77	28.58
20
21	Total Hours		117.67	177.30
Sheet1

Cell Formulas
Range	Formula
G2:H19	G2	=LET(h,IFERROR(--LEFT(E2,SEARCH("h",E2)-1),0),s,SUBSTITUTE(E2,"m",""),m,--IFERROR(MID(s,SEARCH(" ",s),3),s),h+m/60)
G21:H21	G21	=SUM(G2:G19)

Perfect! I did make minor addition for formatting's sake:

=IF(ISBLANK(E2),"",LET(h,IFERROR(--LEFT(E2,SEARCH("h",E2)-1),0),s,SUBSTITUTE(E2,"m",""),m,--IFERROR(MID(s,SEARCH(" ",s),3),s),h+m/60))