Forum Discussion

Marcjc's avatar
Marcjc
Regular Visitor
8 years ago
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 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!

 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    How do you want to display "9 mins" or " 1 hr 22 mins" ?

     

    Thansk
    Raj

    • Marcjc's avatar
      Marcjc
      Regular Visitor

      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.