Time to Seconds Conversion

[nmck86]

Hello,

I have a field in my dataset that is MM:SS I converted it to this... and I want to have another field that displays this in seconds. I am hoping someone can assist me with this one.

https://drive.google.com/open?id=1FbkofaPhI5ouoXk_NLx9YZenTVEA_B9H 

Thanks!

[v-danhe-msft]

Hi @nmck86,

It seemed your link could not be accessed:

Could you please upload it again?

Regards,

Daniel He

[nmck86]

Hello,

I apologize, can we try this link instead. Thanks!

https://drive.google.com/file/d/1FbkofaPhI5ouoXk_NLx9YZenTVEA_B9H/view?usp=sharing

[v-danhe-msft · Accepted solution]

Hi @nmck86,

Based on my test, you could refer to below formula:

TimeInSeconds = (HOUR('Data'[AvgTalkDuration])*60+ 
                 MINUTE('Data'[AvgTalkDuration]))*60

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[AlB]

Hi @nmck86

How about creating a new column like this:

TimeInSeconds =
VALUE ( LEFT ( Table1[Column], 2 ) ) * 60
    + VALUE ( RIGHT ( Table1[Column], 2 ) 

where Table1 is your table and Table1[Column] the column with the MM: SS