Duration Field coming in as date/time

[CharlotteCity12]

I have these fields in my EXCEL sheet:

Duration

0:58:01

1:25:32

0:00:59

When I bring it into PowerQuery it formats it as:

How do I force PowerQuery to bring in this field as just the text? 

[ppm1]

If you convert them to text, they will sort alphabetically and you won't be able to do analysis easily (min, max, avg time). A good practice is to bring them in as time or duration, do your analysis, and then FORMAT it how you like in the measure/visual.

Calculate and Format Durations in DAX – Hoosier BI

Pat

[olgad]

Hi, right click on Duration, Transform, time only