Recognize Time Cells as Numeric Values

[CHML]

Hi.
When downloading a report from a website, I get the number of hours/minutes like the image below. I am looking for an idea of how I can sum these cells, being that Excel does not catch up these as numbers or timing.

 

[Cubist]

I have no clue why it's giving you 0. It works fine for me.

Book1
	F	G
1	Time String	Hours
2	209h 40m	209.67
3	54h	54.00
4	43m	0.72
5	37h 2m	37.03
6	6h 5m	6.08
7	8h	8.00
8	6h 30m	6.50
9	12m	0.20
10	Total	322.20
Sheet3

Cell Formulas
Range	Formula
G2:G9	G2	=IFERROR(--LEFT(F2,FIND("h",F2)-1),0)+IFERROR(IF(ISERROR(FIND("m",F2)),0,--MID(F2,FIND("h",F2)+1,FIND("m",F2)-FIND("h",F2)-1)),--LEFT(F2,LEN(F2)-1))/60
G10	G10	=SUM(G2:G9)

 

[CHML]

Yea, that's a different technical issue that I need to post separately, as I think I had this more than once. All right, thank you very much!!!

 

[Cubist]

You're welcome.