Extended Duration functions

[marcpaige]

I often have to deal with data that are imported from dialers. These data come in a string duration format (e.g. 00:01:12:04 for 1 hour, 12 minutes, and 4 seconds.) I would like to have similar functions to the date/timestamp extraction functions (second, minute, hour, et al). 

I would also like a simple conversion from the string duration to integer milliseconds (the opposite of formatDuration.)

[RADSr]

It would be great to have the built in -- but it would also be great to define it once and save it as a UDF.    <shamelessly lobbying for an upvote 😉  >    

https://community.incorta.com/t5/product-ideas/allow-creation-of-udfs/idi-p/2273