Skip to Content

Converting Seconds to HH:MM:SS and finding 90P

Nov 15, 2017 at 05:31 PM


avatar image

Hi , I have a variable name "Call Processing" which is a time variable currently in just numbers e.g. "00256" seconds.

I would like to convert this variable into a HH:MM:SS format and then find the 90 percentile time. In the 2008 version of Crystal Reports I used to use this formula "

crtimefromsecssincemidnight" but I recently updated my Crystal Reports to the 2016 version and now this formula doesn't work.

Help please

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

1 Answer

Ido Millet Nov 15, 2017 at 07:14 PM

Perhaps you relied on a User Function Library (UFL) for that function.

You can build the logic using Crystal formula logic. See:

If you wish to continue using a UFL, you can try to locate and reinstall that UFL, create your own UFL, or purchase a UFL with that function. See list of UFLs here . My CUT Light UFL provides a uflSecondsToTimeString() function for this.

10 |10000 characters needed characters left characters exceeded