Convert hh:mm:ss am to hh:mm:ss

[siquilesq]

HI, I read my data from excel file, and the column came in this format: hh:mm:ss am

i need to show in duration format:

I will apreciate any help...thanks

[Anonymous]

@siquilesq change the datatype of the duration column to time

Thanks!!

[Rabech]

Clicking the small "ABC123" field next to your column title, you should be able to change the format to duration 🙂

[siquilesq]

I try this dax: 

Avg Handled Duration X = FORMAT(Efficiency[Avg Handled Duration],"HH:MM:SS") but

[siquilesq]

Sorry but I already try this option and not work.,

[Anonymous]

@siquilesq first try converting it to text & then to time

Hope so this helps!!

[siquilesq]

Change to text, trunc the seconds part