Forum

Notifications
Clear all

How to split numbers from hr/hrs/min/mins

3 Posts
2 Users
0 Reactions
137 Views
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Team,

I have to extract numbers only related to hr/hrs/min/mins as shown in expected result.

Is there any way to do that in excel or powerquery.

Thank you.

Regards,

Aye

 
Posted : 23/12/2020 9:12 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Aye,

You can use Power Query for this. See example file attached (note: I deleted quite a few rows as there were way more than enough examples).

Mynda

 
Posted : 23/12/2020 10:06 pm
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Many Thanks, Mynda.

Regards,

Aye

 
Posted : 24/12/2020 12:45 am
Share: