Forum Discussion
Solved
Text to Time - different text format
I know that there are a lot of text / time conversion discussions on the site, but none of them seem to fit my situation. I am hoping someone may be able to assist me with how I can convert the follo...
Marcjc,
Please check if the Power Query code in the following PBIX file returns your expected result.
https://1drv.ms/u/s!AhsotbnGu1Nok3aBo-5kuXIjmgz_
Regards,
Lydia
How do you want to display "9 mins" or " 1 hr 22 mins" ?
Thansk
Raj
Thank you for the quick reply... I am not really worried about how the time is displayed in the converted column in the table because the ultimate goal is to present a single number (count) of the rows that fit the filter criteria.
Sample data for review.
Marcjc,
Please check if the Power Query code in the following PBIX file returns your expected result.
https://1drv.ms/u/s!AhsotbnGu1Nok3aBo-5kuXIjmgz_
Regards,
Lydia
