Forum Discussion

Post Patron

7 years ago

Solved

Time to Seconds Conversion

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
7 years ago
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
Time to Seconds Conversion.pbix158 KB

4 Replies

AlB
Community Champion
7 years ago
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
v-danhe-msft
Microsoft Employee
7 years ago
Hi nmck86,

It seemed your link could not be accessed:

Could you please upload it again?

Regards,

Daniel He
- nmck86
  Post Patron
  7 years ago
  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
    Microsoft Employee
    7 years ago
    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
    
    Time to Seconds Conversion.pbix158 KB

Forum Discussion

Time to Seconds Conversion

4 Replies

Related content

Time conversion

Real-Time Dashboard continuous refresh no longer refreshes faster than 10 seconds

FX Conversion Logic

Web Report doesn't update properly a second time

Handling Time Zone Conversions and Daylight Saving Time in Azure Fabric