Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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: http://www.kenhamady.com/formulas/form09.shtml

    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.

    Add comment
    10|10000 characters needed characters exceeded