Skip to Content

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

Dec 08, 2016 at 05:10 AM


avatar image

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?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Gabriele Bodda
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,

Show 1 Share
10 |10000 characters needed characters left 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,