Number Formatting

[Reec0n]

I export reports and i receive a number format that I need to edit.

What i get is:

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>2.5 hours (150 minutes)

what I would like to replace it with is just the minute amount

150

Have a look at the Google sheet, any help would be greatly appreciated

https://docs.google.com/spreadsheets/d/14GBdAGzHIwq4mvqIpdcAHzmSEktIy_Y5GdMW20PxFEw/edit?usp=sharing

Thank you

 

[FormR]

Hi, here is one way you can try:

Excel 2013/2016
	A	B
1	TimeWorked	Minutes
2	15 minutes	15
3	2.5 hours (150 minutes)	150
4	25 minutes	25
5	15 minutes	15
6	46 minutes	46
7	3.03 hours (182 minutes)	182
8	1.42 hours (85 minutes)	85
9	30 minutes	30
10	55 minutes	55
11	10 minutes	10
12	15 minutes	15
13	20 minutes	20
14	15 minutes	15
15	15 minutes	15
Sheet1

Cell Formulas
Range	Formula
B2	=IF(A2="","",0+RIGHT(SUBSTITUTE(LEFT(A2,FIND("m",A2)-1),"(",REPT(" ",99)),99))

 

[Reec0n]

Hi, here is one way you can try:

Excel 2013/2016

	A	B
1	TimeWorked	Minutes
2	15 minutes	15
3	2.5 hours (150 minutes)	150
4	25 minutes	25
5	15 minutes	15
6	46 minutes	46
7	3.03 hours (182 minutes)	182
8	1.42 hours (85 minutes)	85
9	30 minutes	30
10	55 minutes	55
11	10 minutes	10
12	15 minutes	15
13	20 minutes	20
14	15 minutes	15
15	15 minutes	15

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B2 =IF(A2="","",0+RIGHT(SUBSTITUTE(LEFT(A2,FIND("m",A2)-1),"(",REPT(" ",99)),99)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thank you. This worked perfectly. Much appreciated