With the present data types available in Gainsight we can't access the HH:MM: SS format of the data.
Usecase: While bringing Time duration data into S3 bucket from an external source we are mapping it as a type String because of the format. Now the usecase is to perform aggregation on the Time duration i.e AVG Time spent.
Thank you for your idea.
We have added it to our roadmap