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
TimeWorked	Minutes
15 minutes
2.5 hours (150 minutes)
25 minutes
15 minutes
46 minutes
3.03 hours (182 minutes)
1.42 hours (85 minutes)
30 minutes
55 minutes
10 minutes
15 minutes
20 minutes
15 minutes
15 minutes

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]15[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]150[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]25[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]15[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]46[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]182[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]85[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]30[/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]55[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]10[/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]15[/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]20[/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]15[/TD]

[TD="align: center"]15[/TD]

[TD="align: right"]15[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B2[/TH]
[TD="align: left"]=IF(A2="","",0+RIGHT(SUBSTITUTE(LEFT(A2,FIND("m",A2)-1),"(",REPT(" ",99)),99))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you. This worked perfectly. Much appreciated