Time (minutes and seconds to seconds)

[Doknights]

Hello All, 

I am attempting to build a call centre dashboard and I need some data in seconds in Power Query before I do my measures in Power BI desktop. The minutes and seconds are in one coloum and currently formatted in the way seen in the attached. 

I know that I have to transform the data and remove the date but what is next to have this data converted into seconds as a duration for me to write my measures? 

Appreciate the support. 

[Doknights]

Hey, Thanks but when I convert it to a decimal it is not working. Any way I can convert it to seconds in the current format?

[Anonymous · Accepted solution]

Hi @Doknights ,

Try the following codes:

= Time.Second([Total Talk])+Time.Minute([Total Talk])*60+Time.Hour([Total Talk])*60*60

It takes hours and minutes and converts them into seconds, adding the original seconds.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Anonymous]

I would transform each datetime to a decimal number, and then multiply the result by 86400.

--Nate