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.

Hi@shivani
Thank you for your idea.
We have added it to our roadmap
Thank you
Preethi