Dear Community, I am stuck at a step in trying to convert the time field value to show as MM:SS as the final output on the visual. [image] In the attached image: You can see that I am able to convert the millisecond to MM:SS format and display it in the table using the calculated field as belo…

Hello Tushar, Welcome to the Quick Sight Community. I am not sure if this will help but have a look here - DemoCentral Thank you. Cheers, Deep

Hello Deep, Many thanks for sharing the solution so quickly. I am going to test it out on my use case today and will update before the EoD. Thanks and regards, Tushar

Hello Deep, I tried using the provided solution and it works fine to show each data in the field of the dataset converted to the desired time format I want. See ref screenshot below: [image] This works without any issue. Now what I am trying to achieve further is: [image] in screenshot - ave…

Hello Tushar, See this post if it helps - [image] Convert time duration to HH:MM:SS Articles 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 …

Hi Deep, Thank you sharing the links. I checked them but the issue still exists. As I stated in my reply earlier today that I want that averaged value “273 seconds” to show me as 1 value in visual in either HH:MM:SS or MM:SS format of time. Let me share the question again below using the attached …

Hi Community and @Deep Is it possible to have any further guidance or suggestion with this query? Best Regards, Tushar

Hi, I hope community is reading and can share if it is possible to get some assistance on this thread or not? Regards, Tushar

Hi @tsh1089 , It’s been awhile since last communication on this thread. Checking in to see if you were still having issues with your original topic or if you were able to find a work around? If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic. Thank you!

Hi @tsh1089 , Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information that may be needed. Thank you!

To convert time in milliseconds to MM:SS format

Q&A

Deep August 8, 2024, 9:44am 5

Hello Tushar,

See this post if it helps -

Hope it works for you.

Cheers,
Deep

Topic		Replies	Views
Need to convert the aggregated column to HH:MM format/HH:MM:SS format Q&A quick-sight , calculations , Business-Intelligence-Engineer	10	284	March 1, 2024
Display Time in HH:MM:SS from Time in Seconds in quicksight Q&A filters , formatting , quick-sight , calculations , Business-Intelligence-Engineer	7	1201	February 28, 2024
Display Time in Seconds to HH:MM:SS Q&A formatting , date , quick-sight , calculations , visual , Business-Intelligence-Engineer	3	1304	January 20, 2025
Convert time duration to HH:MM:SS Technical Articles date , duration , calculations	1	5002	November 24, 2023
Seconds (string) to "HH:mm:ss" time convertion Q&A formatting , quick-sight	2	1024	February 21, 2023

To convert time in milliseconds to MM:SS format

Related topics