Skip to main content

    Power BI

    Needs Votes

    Display seconds in hh:mm:ss format

    Vote (32) Share
    Mike's profile image

    Mike on 02 Jul 2016 01:40:40

    Allow creating measures based on values in seconds (i.e AHT, Hold Time ,etc typical call center metrics), but display the result formatted as hh:mm:ss.

    Comments (1)
    Mike's profile image Profile Picture

    Petr on 05 Jul 2020 23:31:51

    RE: Display seconds in hh:mm:ss format

    '@Bill Hoenig: this approach does not work for larger numbers, e.g. TIME(0, 0, 86300) throws error (An argument of function 'TIME' has the wrong data type or the result is too large or too small.)