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.

 

[Joe4]

Do yu mean for 365 (which costs much more) or would 2021 be enough in this case

It looks like those special text functions are only available in Excel 365.

 

[CHML]

Gotcha - Thanks to all of you.

 

[Cubist]

This is one convoluted formula but seems to work. Give it a try.

Book1
	F	G	H
1
2	209h 40m	209:40	<-Formatted as [h]:mm
3	54h	54:00
4	43m	0:43
Sheet3

Cell Formulas
Range	Formula
G2:G4	G2	=IFERROR(--LEFT(F2,FIND("h",F2)-1),0)/24+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))/1440

 

[CHML]

Below is what I get

 

[CHML]

Oh, so that refers to half a day? Cool. So let's finish it. Can you help me get the number of hours?

 

[Cubist]

Try this.

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
Sheet3

Cell Formulas
Range	Formula
G2:G6	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

 

[CHML]

Looks beautiful! But why is Excel not responding when doing SUM?

 

[CHML]

 

[Cubist]

Is the row in which you're putting the sum formula less than row 54?

 

[CHML]

Is the row in which you're putting the sum formula less than row 54?