Notifications
Clear all
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
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
Topic starter
Many Thanks, Mynda.
Regards,
Aye
Posted : 24/12/2020 12:45 am