calculate the number of minutes

[robertvdb]

I have a cell which displays 220:15
For internal reasons, this cell has to be formatted "Custom [h]:mm".

Now I need to calculate the number of minutes = 220*60 + 15 = 13215.

Whatever formula I'm trying does not produce the correct result... Can anyone help ?

 

[RudRud]

Hi, While waiting for other experts for more efficient and effective formula, I will share my thought here

FYR:

Book7
	A	B	C	D
1	220:15	220	15	13215
2	123:153	123	153	7533
3	150:60	150	60	9060
4	532:53	532	53	31973
5	532:53	31973
Sheet1

Cell Formulas
Range	Formula
C1:C4	C1	=MID(TEXT(A1,"[h]:mm"),FIND(":",TEXT(A1,"[h]:mm"))+1,LEN(A1)-FIND(":",TEXT(A1,"[h]:mm")))
D1:D4	D1	=B1*60+C1
B1:B4	B1	=MID(TEXT(A1,"[h]:mm"),1,FIND(":",TEXT(A1,"[h]:mm"))-1)
B5	B5	=MID(TEXT(A5,"[h]:mm"),1,FIND(":",TEXT(A5,"[h]:mm"))-1)*60+MID(TEXT(A4,"[h]:mm"),FIND(":",TEXT(A4,"[h]:mm"))+1,LEN(A4)-FIND(":",TEXT(A4,"[h]:mm")))

 

[Peter_SSs]

23 04 30.xlsm
	A	B
1	220:15	13,215
Minutes

Cell Formulas
Range	Formula
B1	B1	=A1*1440

A1 is custom formatted as [h]:mm as you described.
B1 is formatted as Number with no decimal places.

 

[robertvdb]

Thanks Peter, this does the trick !
Thanks also RudRud, but Peter's solution is obviously shorter

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.