Skip to Content
0

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

Dec 08, 2016 at 05:10 AM

165

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?

Regards,

Saurabh

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

1 Answer

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

Hi Saurabh,

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

Kind regards,
Gab

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,

Saurabh

0