How do I change my query to display time-based results as HH:MM:SS?

Return to top
Have more questions? Submit a request


  • Jackson


    This doesn't appear to be accurate for all time-base results.

    I have a default metric, AVG First reply time - Business hours (min), that's displays 182 minutes as a result. Changing the display format to Duration as instructed makes the format 00:03:02 (DD:HH:MM) and not HH:MM:SS.

    I've also tried this with AVG First reply time - Business hours (hrs). By default, that returns 3.0 hrs. Changing the display format to Duration changes this to ??:DD:HH, or 00:00:03.

    Is there any way for me to standardize all of my time-based results so I don't have to specify these formatting differences in my dashboards?

  • Dan Ross
    Community Moderator

    We're new to explore and would also love to be able to do what Jackson's asking. When we're viewing chat wait times, 1.3 minutes is less helpful and hh:mm:ss breakdowns.

  • Gab
    Zendesk Customer Advocate


    I'm afraid only the attributes displayed in seconds by default can be converted to the format HH:MM:SS. At this time, there is no known workaround to edit the display format of other units of time (attributes in minutes or hours) to be shown in that format. Sorry about this limitation, Dan and Jackson.



Please sign in to leave a comment.

Powered by Zendesk