The easiest thing to do would be to create a three column table valued function that splits the time and converts to seconds. Then you could always add all three colums up. I didn't have time to write it, but I will if you still need help.