Question with duration type

[Anonymous]

Hi all I have an excel file with several agents call center calls, and one of the columns is the duration of the calls. I have changed the type from text to duration, but when I use the score card visual, i only see 0.00 , it does not give me the minutes that is what i want. Is there any way to show all decimals ? as the duration is always on minutes, so i have 0.00.04.27 and things like that . Thanks! César

[Pragati11 · Accepted solution]

Hi @Anonymous ,

You need to create a new column using your "duration" column as per the calculation suggested by @amitchandak 

Thanks,

Pragati

[amitchandak]

@Anonymous , try like in Minute

new column in Minute =left([Duration],1)*24*60 + mid([Duration],3,2)*60 + mid([Duration],6,2)*1+right([Duration],2)/60

[Anonymous]

@amitchandak is this a measure? i think I am a bit lost about what i have to do

Thanks 

[amitchandak]

@Anonymous , New Column. I mentioned that in the name.

[Pragati11 · Accepted solution]

Hi @Anonymous ,

You need to create a new column using your "duration" column as per the calculation suggested by @amitchandak 

Thanks,

Pragati

[Anonymous]

I am a rookie and i think i am lost about how to do that sorry :-S

The name of tjhe column is average time , and the format is 

00:15:28

[amitchandak · Accepted solution]

@Anonymous 

If it text/varchar

new column in Minute =left([Duration],2)*60 + mid([Duration],4,2) +right([Duration],2)/60

If it is time /timestamp

new column in Minute =hour([Duration])*60 + minute([Duration]) +second([Duration])/60

[Pragati11]

Hi @Anonymous ,

1. Just want to check what format did you chnage your TEXT type DURATION column to? Is it time? (hh:mm:ss)
2. Second question is how did you change a text value to DURATION in Power BI?

Refer following article to correctly convert text value to time value.

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati