Forum Discussion
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 following examples from text to time. The ultamite goal I have is to be able to count rows based on a filter that have a 'time less than 4 hours', 'time less than 24 hours', and then 'time greater than 24 hours'. My first step was to be able to convert the column containing these values to Time, but when I try, Power Bi throws a message that it cannot convert the column.
A few text field examples:
9 minutes
34 minutes
12 seconds
1 day 12 minutes
11 hours 3 minutes
Any assistance would be appreciated.
Thank you!
- Anonymous8 years ago
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
5 Replies
- AnonymousNot applicable
How do you want to display "9 mins" or " 1 hr 22 mins" ?
Thansk
Raj