Analytics - String to Duration
Hey friends!
Our calls module is logging the call duration automatically and it's coming into Zoho Analytics as a string. When I try to change the data type from the parent data set, I'm unable to as it's a system table. I'm trying to get around this using a SQL query, but I can't seem to figure out how to do a simple string to duration conversion.
Any ideas?
My string currently looks like %m:%s,
Thanks!