We use the SUBSTITUTE function to replace the colons (:) in our duration text value with the pipe character (|). This allows us to extract the __Hours, __Minutes, and __Seconds using the PATHITEM function. By replacing the colons with pipes, the PATHITEM function can extract each element by specifying where in the hierarchy the element exists. In this case, our hours are in the first element, 1; minutes are in the second element, 2; and seconds are in the third element, 3. Because we are converting this into the number of seconds, we simply need to multiply each of these elements by the number of seconds in an hour and a minute and then add these values together.