Convert Text column to seconds

[yaman123]

Hi, 

Is there a way to convert a text column to show as seconds. The column holds text values in the format of HH:MM. 

E.g 64:56 should show as 233760 seconds. There will be values greater than 24 hours

Thanks

Yasir

[smpa01 · Accepted solution]

@yaman123 

Column 2 =
LEFT ( 'Table'[Column1], LEN ( 'Table'[Column1] ) - 3 ) * 3600
    + RIGHT ( 'Table'[Column1], 2 ) * 60

[amitchandak]

@yaman123 , a new column

in Second = left([Column],2) *60*60 + right([Column],2 )*60