To convert time in milliseconds to MM:SS format

[Deep]

Hello Tushar,

See this post if it helps -

Convert time duration to HH:MM:SS

Sharing a calculated field you can use to convert a numeric field (measured in seconds) into HH:MM:SS format (will become a string). You cannot do any math or date calculations while in this form as the result is a string, but it will work for display purposes (and will sort correctly if you place on an X-axis, table, etc). concat( ifelse({Average Talk Time} / 3600 < 10,concat('0',tostring(floor({Average Talk Time} / 3600))),tostring(floor({Average Talk Time} / 3600))) ,':', ifelse(({Averag…

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…

Hope it works for you.

Cheers,
Deep