Refer this blog post. The explanation looks good and simple
E.g: First you have convert hours into minutes + minutes.
String calculations will come handy. Split functions in the data interpreter might be useful to split hh:mm:ss format.
INT(SPLIT(RIGHT(STR([Field Name]),8),":",1)*60+SPLIT(RIGHT(STR([Field Name]),8),":",2))