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.

 

[Jeffrey Mahoney]

You could add helper columns. Number format like: d "days" hh "hrs" mm "Min"

Book2
	F	G
2	209h 40m	9 days 09 hrs 00 Min
3	54h 43m	2 days 23 hrs 12 Min
Sheet3

Cell Formulas
Range	Formula
G2:G3	G2	=--TEXTBEFORE(F2,"h")/24+(--TEXTBEFORE(TEXTAFTER(F2,"h"),"m")/60)

 

[CHML]

 

[Jeffrey Mahoney]

Change to
=--TEXTBEFORE(F2,"h")/24+IFERROR(--TEXTBEFORE(TEXTAFTER(F2,"h"),"m")/60,0)

 

[CHML]

 

[Cubist]

Book1
	F	G
2	209h 40m	209:40
3	54h	54:54
4	43m	0:43
Sheet3

Cell Formulas
Range	Formula
G2:G4	G2	=SUM(IFERROR(--LEFT(F2,FIND("h",F2)-1),0)/24,--MID(F2,IFERROR(FIND(" ",F2),1),IFERROR(FIND("m",F2),LEN(F2))-IFERROR(FIND(" ",F2),1))/1440)

 

[CHML]

Please explain?

 

[Cubist]

Please explain?

The functions Jeffrey proposed do not exist in 2019, giving you #NAME error.

 

[Jeffrey Mahoney]

@CHML I strongly suggest upgrading if you can.

 

[CHML]

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