Forum Discussion

yaman123's avatar
yaman123
Post Partisan
4 years ago
Solved

Convert Text column to seconds

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 th...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • smpa01's avatar
    smpa01
    4 years ago

    yaman123 

     

    Column 2 =
LEFT ( 'Table'[Column1], LEN ( 'Table'[Column1] ) - 3 ) * 3600
    + RIGHT ( 'Table'[Column1], 2 ) * 60
amitchandak's avatar
amitchandak
Super User
4 years ago

yaman123 , a new column

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