How to do it...

To implement this recipe, do the following:

1. Create a column in the R10_Table table with the following formula:

Duration2Seconds = 
    VAR __Duration = 'R10_Table'[Duration] 
    VAR __Sub = SUBSTITUTE(__Duration , ":" , "|")
    VAR __Hours = VALUE(PATHITEM(__Sub , 1)) * 3600
    VAR __Minutes = VALUE(PATHITEM(__Sub , 2)) * 60
    VAR __Seconds = VALUE(PATHITEM(__Sub , 3)) * 1
RETURN __Hours + __Minutes + __Seconds