Hello @s4doto, welcome to the QuickSight Community! There is definitely a route to resolve this, but it is a little complex so I’ll try to give some details.
These steps should get you close to the result you are looking for:
- Split the string into 3 fields- Hours, minutes, and seconds using this substring function.
- For each new field you can parse it to an integer with parseInt() and then I would recommend converting each to seconds
- create another calculated field that will then create the new format. I am going to link this demo analysis that was built by AWS. This is an amazing tool for this specific functionality and has pre-built calculated fields that you can dig into.
For more information, this is also a link for another QuickSight community question that was asked/answered related to this topic.
Let me know if this helps!