Skip to Content

Convert Ticket Handling Time Key figure in DD:HH:MM:SS format

Hi Experts,

We have an existing key figure Ticket Handling Time but in seconds format. Now I want to convert this into Days:Hours:Mins: Secs format. I have converted this into H:M:S format by using TIME(Ticket Handling Time) Formula. Can anybody please help me how can I convert this in D:H:M:S format?

Regards,

Saurabh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 19, 2016 at 06:36 PM

    Hi Saurabh,

    The DD:HH:MM:SS format is not supported. You may need to show the information using two fields.

    Kind regards,
    Gab

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Gabriele,

      Thanks for replying. Can you please explain how can I do this? I'm not able to understand your point. Can you please help me like how can I show the information using to fields?

      Best Regards,

      Saurabh