Genesys Cloud - Main

 View Only

Sign Up

  Thread closed by the administrator, not accepting new replies.

  • 1.  Time format without milliseconds

    Posted 09-06-2023 11:00
    No replies, thread closed.

    Hello,

    Is there a way to have time format without milliseconds when extracting datas from interactions ? I just need hours, minutes and seconds.

    Thanks


    #Reporting/Analytics

    ------------------------------
    Julien HAZARD
    Nordnet
    ------------------------------


  • 2.  RE: Time format without milliseconds

    Posted 09-12-2023 17:34
    No replies, thread closed.

    Hi Julien,

    We currently do not have that format option with exports.  We do have an update that will be in beta soon.  We will be providing an additional format option (seconds) for duration columns.  Please create an Idea in the ideas portal for your desired format option so we can track it.

    Thanks!

    Greg



    ------------------------------
    Greg Cole
    Genesys - Employees
    ------------------------------

    Original Message


  • 3.  RE: Time format without milliseconds

    Posted 09-13-2023 08:23
    No replies, thread closed.

    If exporting the Interaction view as a CSV file to use with Excel don't select the Format Durations checkbox 

    Use the following formula to convert the duration in milliseconds to a day fraction .... stay with me on this :)  

                = A1 / (1000 x 60 x 60 x 24)  

    Where A1 is cell with milliseconds time value 

               1000 is the milliseconds in a second

                60 is the seconds in a minute 

                60 is the minutes in an hour 

                24 is the hours in a day 

    Apply a time format to the value to display it as hours minutes and seconds.  

    Excel formula and formatting

    An advantage of doing all this is you can add, subtract, multiple and divide the values too.  

    Note: you can substitute 86,400,000 for 1000 x 60 x 60 x 24 , but I remember it as the individual terms 

    Go a step further and automate the transformation using Excel's Power Query



    ------------------------------
    Jonathan Bartelt
    Advocate Aurora Health, Inc.
    ------------------------------

    Original Message


Related Content