Display Time in HH:MM:SS from Time in Seconds in quicksight

[teja1]

Hello @duncan, kindly check out the following link:

Display Time in Seconds to HH:MM:SS

Hello everyone, I wanted to share a solution I found for converting seconds to HH:MM:SS in Amazon QuickSight. When using the formula provided by the QuickSight community in a calculated field, the result is in string format, which isn’t suitable for aggregation. After searching for a solution and not finding any source, I managed to figure it out. Here’s a step-by-step guide: Step 1: Create a calculated field (e.g., “SumTimeInterval”) and use the formula: sum(seconds) Step 2: Create anoth…