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 than 24 hours

 

Thanks

 

Yasir

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

2 Replies

  • smpa01's avatar
    smpa01
    Community Champion
    4 years ago

    yaman123 

     

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